AutoHotkey Community

It is currently May 27th, 2012, 11:59 am

All times are UTC [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
PostPosted: November 15th, 2010, 9:09 pm 
Offline

Joined: October 15th, 2006, 2:39 am
Posts: 93
Location: Croatia
A little trick I thought I'd share with you all.

As I was archiving my stuff, I found that my Firefox (Portable) profile folder is over 100 mb, mostly because of 2 files: urlclassifier3.sqlite (>30mb) and places.sqlite (>20mb).
The first one is just a local database of bad/phishing/etc. sites, it's more or less not needed, ffox will rebuild it if you delete it.
The second one, places.sqlite contains important stuff (bookmarks, history etc.), but it can become unnecessary bloated over the time even if it doesn't contain much data.
First I cleared history (guess it made it a bit smaller on the inside).

Then I found that there's a tool called sqlite3 that can clean it up and make it smaller.
And it goes a little something like this:
Download zip, then extract sqlite3.exe your <profile> folder where places.sqlite file is.
Open command prompt and type:
Code:
sqlite3 places.sqlite vacuum

After it's done, the 30+ mb file shrunk to 500 kb and my Firefox starts up about 5 times faster (well, obviously, 'cause it has less data to process).

I hope people out there will find this useful.
:arrow: Standard disclaimer: don't blame me if you break something
Quote:
I can only show you the door. You're the one that has to walk through it.


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: November 15th, 2010, 10:18 pm 
Offline

Joined: May 2nd, 2006, 11:16 pm
Posts: 800
Location: Greeley, CO
CCleaner by Piriform, a free and fairly thorough system cleanup utility, also offers the ability to compact your Firefox databases.

Piriform also offers three other free tools;
    Defraggler (defragger)
    Recuva (file recovery)
    Speccy (system spec tool)

_________________
Image
SoggyDog
Dwarf Fortress:
"The most intriguing game I've ever played."


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: November 16th, 2010, 12:09 pm 
Offline

Joined: February 28th, 2008, 8:02 pm
Posts: 100
Location: Krk, PL
There's Vacuum Places - addon that let's you automate the cleanup.

_________________
Benjamin Franklin wrote:
Anyone who trades liberty for security deserves neither liberty nor security.


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: November 16th, 2010, 11:29 pm 
"sqlite" is actually a database file, based off SQLite - it's so fast, small and efficient, it can run a database in-memory (imagine that!)

The "vacuum" option removes all deleted records and just leaves the live ones.


Report this post
Top
  
Reply with quote  
 Post subject:
PostPosted: November 16th, 2010, 11:48 pm 
Actually, sorry to hijack this thread, but if you really want to speed up your Firefox startup, install the "Bar Tab" add-on!


Report this post
Top
  
Reply with quote  
 Post subject:
PostPosted: November 17th, 2010, 8:13 pm 
Offline

Joined: May 2nd, 2006, 11:16 pm
Posts: 800
Location: Greeley, CO
Guest wrote:
Actually, sorry to hijack this thread, but if you really want to speed up your Firefox startup, install the "Bar Tab" add-on!

Helpful only if you leave a boat-load of tabs open in Firefox when you close that all have to open back up when you re-launch;
Otherwise, entirely useless in the context of this thread.

_________________
Image
SoggyDog
Dwarf Fortress:
"The most intriguing game I've ever played."


Report this post
Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Powered by phpBB® Forum Software © phpBB Group