FIREFOX - performance improvement by cleaning up sqlite database


----------------------------------------------------------------------------
LINUX COMMAND:  cd /home/luser/.mozilla/firefox/PROFILE-NAME.default ; sqlite3 places.sqlite "vacuum;"
    (you may need to install sqlite3, see details below)
    NOTE:  most Linux distros will have this same path, however the install of the tool will vary

MAC COMMAND:     cd ~/Library/Application\ Support/Firefox/Profiles/*.default/ ; sqlite3 places.sqlite "vacuum;"
----------------------------------------------------------------------------



LINUX PROCESS:   


1) open a terminal window (Konsole)
2) QUIT firefox; verify it's not running
3) cd to the firefox profile directory for your account
4) execute the command to vacuum 
5) restart firefox and enjoy

----------------------------------------------------------------------------
-> cd /home/luser/.mozilla/firefox/PROFILE-NAME.default 
----------------------------------------------------------------------------
    you can cd to this path with a shell shortcut:   
    cd ~/.mozilla/firefox  and then your unique profile name, 
        or type *.default in the path 
    cd ~/.mozilla/firefox/*.default 
----------------------------------------------------------------------------
check to make sure you are there:
----------------------------------------------------------------------------

-> pwd
/home/luser/.mozilla/firefox/PROFILE-NAME.default
----------------------------------------------------------------------------

-> ls places.*
rw-r--r--  1 luser luser 36700160 Aug  2 10:26 places.sqlite
-rw-r--r--  1 luser luser    32768 Dec 13  2018 places.sqlite-shm
-rw-r--r--  1 luser luser  4096000 Aug  2 10:58 places.sqlite-wal
----------------------------------------------------------------------------
MAKE SURE FIREFOX is not running

--> ps -ef | grep -i firefox
luser      9424  8008  0 11:04 pts/1    00:00:00 grep -i firefox
----------------------------------------------------------------------------

clean the database - the tool may not be installed on your distro, YMMV:
----------------------------------------------------------------------------
--> sqlite3 places.sqlite "vacuum;"

Command 'sqlite3' not found, but can be installed with:

sudo apt install sqlite3

------------------------------------------------
luser@mint-linux [/home/luser/.mozilla/firefox/PROFILE-NAME.default]
------------------------------------------------
--> sudo apt install sqlite3
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following package was automatically installed and is no longer required:
  libllvm7
Use 'sudo apt autoremove' to remove it.
Suggested packages:
  sqlite3-doc
The following NEW packages will be installed:
  sqlite3
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 753 kB of archives.
After this operation, 2,481 kB of additional disk space will be used.
Get:1 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 sqlite3 amd64 3.22.0-1ubuntu0.1 [753 kB]
Fetched 753 kB in 1s (629 kB/s)  
Selecting previously unselected package sqlite3.
(Reading database ... 268907 files and directories currently installed.)
Preparing to unpack .../sqlite3_3.22.0-1ubuntu0.1_amd64.deb ...
Unpacking sqlite3 (3.22.0-1ubuntu0.1) ...
Setting up sqlite3 (3.22.0-1ubuntu0.1) ...
Processing triggers for man-db (2.8.3-2ubuntu0.1) ...

------------------------------------------------
luser@mint-linux [/home/luser/.mozilla/firefox/PROFILE-NAME.default]
------------------------------------------------

--> sqlite3 places.sqlite "vacuum;"

------------------------------------------------
luser@mint-linux [/home/luser/.mozilla/firefox/PROFILE-NAME.default]
------------------------------------------------
--> ll places.*
-rw-r--r-- 1 luser luser 31555584 Aug  2 11:06 places.sqlite

JohnMeister.com Today's Date:

Simply Linux: Basics Using BASH on Windows 10
Practical Suggestions for Microsoft Windows
Linux Tackles Microsoft  Full Size Jeep Buyer's Guide
Video Course:
The Art of Linux System Administration, and a
Study Guide for the LPIC-2 Certification Exams.

-- O'Reilly Media author info
FULL SIZE JEEP

Buyer's Guide

SJ Jeeps

"Jeep is America's
only real sports car."
-Enzo Ferrari


Mercedes, VW, and other Diesels
Nikon cameras
general tech info
AMSOIL product guide,
or, AMSOIL web, or 1-800-956-5695,
use customer #283461

Amsoil dealer since 1983

purchase AMSOIL and have it
installed locally in WA at:

- Northland Diesel 360.676.1970 - Bellingham
- Midway Auto 360.668.7111 - Clearview/Snohomish
- Fleet Services 425.355.4440 - Everett