Very slow response and memory problem with etemplates autorepeat

[sachingp]

Hi,

I am using etemplates + dbtools to display all rows in a table using the autorepeat functionality of the grid-widget as explained in tutorial at http://www.egroupware.org/index.php?page_name=wiki&wikipage=CodeCorner5
It’s working well as explained in the tutorial for small number of rows. But it’s very slow and taking lot of memory when it has lot of rows to display.

I need to display around 2500 rows. But when I tried it, it showed following error:

“Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 35 bytes) in /var/www/egw/etemplate/inc/class.boetemplate.inc.php on line 649”

To fix this, I increased php memory_limit to 128 M in /etc/php5/apache2/php.ini, but that did not fix it. I then inserted
– ini_set(“memory_limit”, “64M”); – into the display function of class.uiabcinc.php and then got following error:

Fatal error: Maximum execution time of 60 seconds exceeded in /var/www/egw/etemplate/inc/class.boetemplate.inc.php on line 649

Any ideas to fix this problem? Are 2500 rows too many for etemplate autorepeat system to work with?

Thanks,

[Nathan_Gray-2]

…I need to display around 2500 rows.
… Are 2500 rows too many for etemplate autorepeat system to work
with?

Depends on your hardware, but 2500 rows are too many for people to
deal with.
Unless you’ve got a screen that makes the rest of us drool, you can’t
fit more than about 50-100 rows on the screen at any one time. Nobody
is going to read 2500 rows at once, it doesn’t matter what they contain.

You should use the nextmatch widget to paginate your rows into chunks
that a user can handle. In addition to solving your size problems,
you will also be able to easily set up searching, sorting and
filtering so users can get the rows they’re interested in.

Nathan Gray
nathan at goarctic dot com

---

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers