Has anyone created an archiving strategy when their audit tables have started to get alot of data in them? Or is there a indexing strategy that would help?
I have about 14 months of heavy usage and my reports are starting to slow down.
What type of table are you putting the audit logs into?