On Tue, Jan 02, 2007 at 12:47:47PM +0000, Kevin Campbell wrote:
> On Wed, Dec 13, 2006 at 10:57:58AM -0500, S.J.Stanaitis wrote:
> > No problems since I did the big purge of old tickets in MailManager, right
> > now however the Reports seem to take a long time to even access the menu...
> > sometimes getting a Zope error... Any ideas to speed it up?
>
> Sam,
>
> What version of MailManager are you running and what database backend?
> There are quite a lot of changes to reporting in the 2.1 branch to deal
> with large datasets. The solution may be to upgrade.
Sam,
Sorry, just noticed the subject line. There are a couple of things you
can do here:
a) run a full vacuum on the database, which should improve
performance
b) Turn on postgres command string debugging (log_statement = 'all')
so that you can use select * from pg_stat_activity to see what
running statements are slowing the process
c) upgrade to 2.1, which should use caches for daily and snapshot
reports, rebuilt nightly.
Regards,
Kevin
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Mailmanager-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mailmanager-users
