recipients overview page slow

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

jhagstrand
Posts: 22
Joined: Thu Apr 17, 2008 8:38 pm

recipients overview page slow

Post 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
pheelix
Posts: 101
Joined: Thu Nov 20, 2008 4:34 pm
Location: Dresden, Germany
Contact:

Post by pheelix »

maybe you could try the same query on the cli and see whether it takes as long as in the webinterface.
jhagstrand
Posts: 22
Joined: Thu Apr 17, 2008 8:38 pm

Post 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
pheelix
Posts: 101
Joined: Thu Nov 20, 2008 4:34 pm
Location: Dresden, Germany
Contact:

Post 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?
maschoff
Site Admin
Posts: 2596
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Post 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.
OpenEMM Maintainer
Post Reply