AnsweredAssumed Answered

Audit Query Performance

Question asked by garryw on Aug 10, 2012
Latest reply on Aug 15, 2012 by garryw

We have recently started using the auditing with the configuration based upon the default alfresco-access audit application with a couple of extras and the performance of the queries is really slow, taking just over 19 minutes to query directly using the service/api/query url.

There is currently approximately 15000 audit entries spanning across 10 days.  The concerns I have is that over a six month period the data is going to become completely unusable. The main reason behind querying them all is to enable them to be exported/downloaded to a usable format by the user.

Any advise on improving the performance of this would be greatly appreciated.