VACUUM Firefox databases and REINDEX

A cunning trick to improve the speed of your browser like firefox's sqlite data base vakumirate. VACUUM process rebuilds the database thus it defragment, decreased size and it makes searching faster, disk usage more efficient and possibly decreased load on your disk as read in the sequence of my sectors. In general this applies to each database that does not perform automatic vacuum/defrag to yourself.

The mere process of defragmenting the database of Firefox is pretty trivial – We perform sqlite3 db-file VACUUM in the profile directory of firefox. In the linux path is usually ~/.mozilla/firefox/random-name.default. In General, you should have only 1 dirketoriâ in mozilla/firefox. If you have more you can check ~/.mozilla/firefox/profiles.ini for the correct directory is your browser's profile. Since I'm not engaged to perform the process manually raspish basic script which Defragmenter database:

for db in $(find ~/.mozilla/firefox/$(grep Path ~/.mozilla/firefox/profiles.ini | cut -d'=' -f2) -maxdepth 1 -name "*.sqlite" -type f)
   echo "VACUUM ${db}"
   sqlite3 ${db} VACUUM
   sqlite3 ${db} REINDEX

After the script runs the search in history-it is self-charging lisik is sensitive faster. The script I think with small modifications you can use in Mac OS.

p.Here's the version for Mac OS X – tested on Mac OS X Sierra. To forename delimiter to be new order, because of the space in the path to the folder which contains the firefox profile

for db in $(find ~/Library/Application\ Support/Firefox/$(grep Path ~/Library/Application\ Support/Firefox/profiles.ini | cut -d'=' -f2)  -maxdepth 1  -name "*.sqlite" -type f)
echo "VACUUM && REINDEX ${db}"
sqlite3 "${db}" VACUUM;
sqlite3 "${db}" REINDEX;

leave a reply

Your email address will not be published. Required fields are marked *

anti SPAM *