[opencms-dev] Alkacon newsletter admin performance

[Mike Dikan]

No one has any tips?  I'd be happy to provide more details if necessary.

On Oct 1, 2009, at 9:47 PM, Mike Dikan wrote:

> Hello,
>
> I am using opencms 7.0.5 and the oamp newsletter module 1.0.1, and  
> have migrated into opencms a newsletter user base of roughly 100,000  
> users.  I am running into some serious performance issues in the  
> newsletter admin page for 'subscriber management' and find that it  
> takes in the 10's of minutes for these pages to load.  At first I  
> thought that I might be able to speed things up on the DB side by  
> adding some indices, but that turned out to be a dead end, as  
> everything that should be indexed already is. Watching the database  
> logs, it looks like the subscriber page is loading all of the data  
> in the 'CMS_USERDATA' table for all of the users, not just the  
> current result-set.  Has anyone else run into this problem and found  
> a good way to speed things up?
>
> Thanks,
> Mike