Firefox 3.6 vs 8.0

Re:Firefox 3.6 vs 8.0 by nodata on Tuesday December 06, 2011 @03:28AM (#3318534)

To defrag your databases, first close Firefox then run:

  for i in ~/.mozilla/firefox/*default/*ite; do sqlite3 $i vacuum; done

[ Parent | on HN ]

Re:Firefox 3.6 vs 8.0 by gcp on Tuesday December 06, 2011 @03:54AM (#3318587)

Note that this does not defragment the storage on disk, just the internal SQLite pages. So it's not a complete solution.

[ Parent | on HN ]

Re:Firefox 3.6 vs 8.0 by nirbheek on Tuesday December 06, 2011 @04:04AM (#3318602)

Actually, that command will also rewrite the entire .sqlite file, and if you have enough free space, the filesystem will most likely rewrite it in a contiguous manner.

I tested this with filefrag.

[ Parent | on HN ]