Is there a limit to number of records displayed?

Archived from the Xataface Users forum.

macassist — Sun Nov 11, 2007 5:36 pm

Hi there,

When I change the number of records I want to see from 30 to a largeish number (for a sales report being run once a week), I sometimes get empty pages (no header or anything) - the sorts of numbers we’re looking at is somewhere in the 2000-4000 range that it craps out (I haven’t determined the cutoff point, but it’s over 1500).

Is this likely to be a Dataface problem, a PHP problem, MySQL, Apache (under WAMP)? Any thoughts gratefully accepted.

Sean

---

shannah — Sun Nov 11, 2007 6:20 pm

The issue is mainly execution time and memory. 1500 records can take a lot of time to render, and a lot of memory to process.

So. Increase the memory limit as much as possible, and increase your allowed execution time.

You can increase memory with the memory_limit ini directive:

e.g ini_set(‘memory_limit’, ‘100M’);

You can increase the execution time limit with the set_time_limit() function.

-Steve

---

macassist — Mon Nov 12, 2007 6:44 pm

Hi Steve,

thanks for the prompt reply on this one, too - the memory limit setting allowed the 5000 records to come through for last month’s report - thanks for that (I’d already increased the timeout).

Regards

Sean