Solutions with a lot of background updates on the products will increase the audit storage in DB very quickly. They often forget to set the cleaning time for audit logs. This will result in poor BO performance.
I remind you if you have not set a time for this to get cleared then set a time which matches the organization solution.
For older versions < L7.3 refer to this topic.