If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Audit Reporting Slowing down

Started by kmuller, 04 Feb 2009 11:07:52 AM

Previous topic - Next topic

kmuller

Has anyone with a large environment that has been running for over 6 months seen their audit reports slow down?  I have a customer facing report that track the number of times users have run certain reports.  This report is getting slower and slower and is terrible during the day as users are running reports and other trying to view the log information.

I have tried indexing the tables, and have even put a view out to report off of but reporting is still slow.

It has to be due to all the writes happening the same time the reads are on the logging tables.

Has anyone implemented a solution that solves this problem?

Thanks

Kevin