yaniv14 Posted April 27, 2017 Share Posted April 27, 2017 TB (as well PS) is saving allot of statistics information that increase the DB size allot. Usually I truncate those tables manually to reduce DB size. So I think we should have an option in the BO to do that process, either by truncating or deleting rows. I am talking about: connections, connectionssource, connectionspage = saves IP address, referrer, etc.... of connection guest = saves guest information (similar to GA) page_viewed = well.... you know pagenotfound = same....... This is nice info to have but in 99% of websites are useless, plus you have GA/Piwik for all that information and more. In some cases those tables can reach 100MB-500MB (depend how many years your site in running). I had one case that I tried to backup a client DB and it ended up in 750MB, after truncating those tables the same DB was only 11MB. Now, I am no SQL expert but I believe that smaller db will execute faster. Link to comment Share on other sites More sharing options...
roband7 Posted April 27, 2017 Share Posted April 27, 2017 If you intend to use GA or Piwik, why not just disable all the Analytics and Stats modules? That way the database tables never grow in the first place, and you avoid some processing overhead too. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now