Page 1 of 1

Other SQLite databases?

Posted: 24 Jan 2014, 16:39
by quickfold
I don't know much about SQLite, so sorry if these are ignorant questions:

Does SpeedyFox make Firefox faster by vacuuming, compressing, and/or rewriting the SQLite databases? Or is something else going on?

Is there any reason that it would be difficult to set up SpeedyFox so that I could point it to any SQlite database and have it make it faster? I think that would be very useful.

If not, is there a free program that does that?

Thanks!

Re: Other SQLite databases?

Posted: 25 Jan 2014, 20:05
by Steven
Please read the complete info at:
http://www.sqlite.org/lang_vacuum.html

You can any program that supports direct sqlite queries, open desired sqlite file and run the VACUUM; command.

Re: Other SQLite databases?

Posted: 25 Jan 2014, 20:46
by quickfold
Thanks. I still am curious about what SpeedyFox does to make Firefox faster: is it just vacuuming? Or is something else going on? I want to know whether vacuuming an SQlite database used by a different program will make it faster to use.

Re: Other SQLite databases?

Posted: 25 Jan 2014, 20:56
by Steven
Only vacuuming.