Jump to content
thirty bees forum

Truncate Db tables from BO


yaniv14

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...