We have discontinued this forum and moved support tickets to the GitHub issue tracker. More info

Other SQLite databases?

Top popular freeware SpeedyFox
Post Reply
quickfold
Posts: 2
Joined: 24 Jan 2014, 16:26

Other SQLite databases?

Post 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!
User avatar
Steven
CrystalIDEA Developer
Posts: 2294
Joined: 21 Dec 2009, 11:48
Location: CrystalIDEA headquarters
Contact:

Re: Other SQLite databases?

Post 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.
quickfold
Posts: 2
Joined: 24 Jan 2014, 16:26

Re: Other SQLite databases?

Post 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.
User avatar
Steven
CrystalIDEA Developer
Posts: 2294
Joined: 21 Dec 2009, 11:48
Location: CrystalIDEA headquarters
Contact:

Re: Other SQLite databases?

Post by Steven »

Only vacuuming.
Post Reply