Since Firefox 3.0, bookmarks, story as well as many storage is kept in SQLite databases. Also, a default story time camber was lifted from 9 to 90 days as it became some-more discoverable as well as utilitarian interjection to a overwhelming bar, so depending upon your browsing day to day it could paint a little flattering vast databases.
Aas any alternative database, SQLite databases turn fragmented over time as well as dull spaces crop up all around. But, given there have been no handling processes checking as well as optimizing a database, these factors in a future outcome in a opening hit. So, a great approach to urge startup as well as a little alternative bookmarks as well as story associated tasks is to defragment as well as trim new space from these databases.
To do this:
Step 1: get sqlite3, a singular record authority line SQLite database manager, for your height (available for Linux, Windows, as well as Mac OS X).
Step 2: Copy a downloaded binary to your form printed matter where all your .sqlite files reside.
Step 3: Close Firefox.
Step 4: From a authority line prompt in your form folder, run:
sqlite3 [SQLite database] VACUUM
replacing [SQLite database with a name of a SQLite file, similar to places.sqlite.
On Windows, to defragment all SQLite databases in a single command, run:
for %a in (*.sqlite) do (sqlite3 %a vacuum)
I ran a book in a integrate of machines ensuing in a conspicuous rebate of begin up times after databases defragmentation:
Machine 1: 1 window, twenty tabs
places.sqlite distance prior to vacuum: 10 MB
places.sqlite distance after vacuum: 9 MB
Cold startup Before: eleven s
Cold Startup After: 8 s
Machine 2: 3 windows, twenty-five tabs
places.sqlite distance prior to vacuum: 40 MB
places.sqlite distance after vacuum: twenty-seven MB
Cold startup Before: 10 s
Cold Startup After: 7 s
So if this is all good, because hasn’t Mozilla enclosed this defragmenting procedure? The thing is they wish to though still haven’t found a most appropriate approach to do so. One of a suggestions so distant has been to do it during an update: it has a value of been almost unchanging (about each 6 weeks), as well as already interrupts a user workflow (and requires a database files been released, branch Firefox off).
A great choice for Windows users is IniFox, by InfoSpyware which simply packs sqlite3 as well as an interactive collection record which defragments all databases in your form as described above. You will still have to download as well as copy, though we will equivocate opening a console as well as repeating a stairs for all a databases.
If we try this mechanism, greatfully take a little time to get your prior to as well as after times as well as sizes as well as share your formula in a comments. For cold startups, we will have to restart your complement to get current results.
Related Posts
- SQLITE3 3.6.21
- SQLITE EXPERT PERSONAL 2.3.51
- SQLITE EXPERT PROFESSIONAL 2.3.51
- WINDOWS XP TIPS – FIREFOX ADDONS – BACKUP FIREFOX
- TRAINSIGNAL MS ACCESS 2007 WHEN DATABASES ATTACK TRAINING DVD
- SHARPPLUS SQLITE DEVELOPER V3.6.1.455
- CLAMWIN VIRUS DATABASES 12 MARCH 2010
- FIREFOX 64BIT X64 3.6.0
- FIREFOX 3.5 3.5.8
- WINDOWS XP TIPS – FIREFOX ADDONS – ADBLOCK PLUS
