js_res_audit_log over 3gb...

nwrightau,

if you dont need the audit log function, you can disable it and empty the table. I presume the "slowness" is not caused by the auditlog, but other settings.

There are a lot of ways speeding up the default installation of Cobalt 8 depending on your setup. Example : Using multi-type sections cause a slowdown in quite some parts of your site.

See http://docs.mintjoomla.com/en/cobalt/optimization/

Try to switch on debug mode for special user and check the result. It can give quite some clues where to improve your settings.

You can adjust settings in your TYPE setting under "Audit Trail". Either switch the audit log off or adjust the actions to be recorded.

Thanks for the response, is there a quick way to globally turn off the audit trail in the database?

I'll take a look at that article as well thankyou. Surely even the audit log should be automatically cleared once it gets to a certain amount of records.

The only way to turn of the audit trail is by going through every TYPE setting. Set "Enable audit log" to NO.

If you want to keep the audit trail, but want to make it smaller, just select only the needed actions to be recorded. "Log records view" might create a lot of entries if you have a busy site. Same with comments if you use it.

As of now there is no function to clear or backup the audit log periodically.

To achieve best performance of Cobalt, avoid multi-type sections, no hidden and unpublished records, check your filter settings ...

If your users will add a lot of records, you might even think of removing some of the default table indices if you dont need specific sort orders to overall improve the submission speed of records.

Just turn it off as suggested and run TRUNCATE queries over that table. You can also clean _js_res_hits table that can also grow big.