Page 1 of 1

recipients overview page slow

Posted: Fri Oct 16, 2009 12:17 am
by jhagstrand
Hi. It now takes about 30 seconds to display the Recipients Overview page, regardless of the selection criteria. We have 2.5 million recipients. How can we speed up this display? Thanks. John

Posted: Fri Oct 16, 2009 9:02 am
by pheelix
maybe you could try the same query on the cli and see whether it takes as long as in the webinterface.

Posted: Fri Oct 16, 2009 5:46 pm
by jhagstrand
Hi Pheelix. Thanks for the suggestion. When I first click "Recipients-Overview", it takes 30 seconds for the screen to appear. It displays the first 50 recipients. I can get the same list directly from MySQL with the query "select * from customer_1_tbl limit 50" in less than one second. John

Posted: Sat Oct 17, 2009 9:22 pm
by pheelix
you may try to enable mysql-logging and follow it in real-time on the shell and see whether it does also run within 1 second there.

you can also try to look through the openemm-logfiles whether there is a problem.

or check the system-load during the page loads. maybe the java- / resin- / mysql-process is on 100% load.

or maybe your server run out of memory and switches to swap?

is your database on the same machine as the openemm application?

Posted: Sat Oct 24, 2009 11:21 am
by maschoff
Honestly, OpenEMM was never intended for such big lists. But if someone is willing to provide code to tune OpenEMM we will happily integrate the code in the next release.