Tomorrow Posted January 9, 2011 Report Share Posted January 9, 2011 I noticed that with this: http://sourceforge.net/projects/sqlitebrowser/ I can issue the VACUUM command to be carried out on Ketarins database and i was wondering...could this have some negative effects on the long run?.I mean maybe Ketarin has reserved some free space on the database and i suddenly vacuum it then it could create problems? Im not too concerned that this won't make any huge difference(e.g gains are small).Im mainly concerned if it's ok to do on a regular basis?.I have issued the VACUUM command to my Firefox databases for more than a year on a regular basis and nothing has broken. When i tested it the database went from 450KB to 390KB (Little over 13% reduction). Link to comment Share on other sites More sharing options...
CybTekSol Posted January 10, 2011 Report Share Posted January 10, 2011 I've been using it for months now with no adverse effects and a negligible gain in performance... of course, I archive jobs.db on a regular basis just in case. Link to comment Share on other sites More sharing options...
josh Posted January 10, 2011 Report Share Posted January 10, 2011 Yep so do I ... I used to do this for a while ... but I don't think it's really needed. Link to comment Share on other sites More sharing options...
Tomorrow Posted January 10, 2011 Author Report Share Posted January 10, 2011 Thanks.Now i have to see how to do this via commandline 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