Suspected PayPal Hackers Seek Deal To Stay Out Of Prison
Did A Google Earth Mistake Cause A Couple's Brutal Murder?
Speed up Firefox by cleaning out your SQLite databases
At Mozilla Links, they've shared another handy tip from Mozilla developer Jeremy Orem.
His advice: take a vacuum to your SQLite databases. Here's how to do it:
- Open the Firefox tools menu and click on error console.
- Paste the following command into the code box as a single line (as pictured):
Components.classes["@mozilla.org/browser/nav-history-service;1"].getService(Components.interfaces.nsPIPlacesDatabase).DBConnection.executeSimpleSQL("VACUUM"); - Hit [enter] or click the evaluate button.
[via Lifehacker]
Comments
12
Subscribe to commentsTaaiAug 24th 2009 6:14PM
And all the time I tough that huge pile of bookmarks are slowing down my browser... This does the job just fine. Thank you!
SimonAug 24th 2009 6:39PM
Appears to work in FF 3.5 only (I haven't yet upgraded for various reasons).
der_tuxmanAug 24th 2009 6:42PM
You can also do that via batch file / shell script:
http://www.gettingclever.com/2008/06/vacuum-your-firefox-3.html
KevinAug 24th 2009 7:03PM
Can you explain further what the SQlite database is responsible for in Firefox and how often it can/should be done? Seems weird to just explain how to fix something without explaining what it's fixing or how often it can be done.
iofthestormAug 24th 2009 7:38PM
The SQLite database is the backend for bookmarks and history. The bookmarks/history system has been this way since Firefox 3, and is called Places.
KevinAug 24th 2009 9:35PM
@iof
Thanks for the info.
minibarAug 25th 2009 1:55AM
http://kb.mozillazine.org/Profile_folder_-_Firefox
according to mozilla urlclassifier3.sqlite is for phishing (malware) protection.
however, i'm unsure why it fragments and bloats so much or how important this becomes. from what i'm reading before these are typically around 50mb and after around 30mb--mine is 44mb after.
while looking into this i discovered an important settings in about:config that deals with the issue in tools->options where history or cache is kept for a minimum number of days but typically grows far beyond. dls's thesmilkman on comment number 5 in this post covers it. idk if there's any performance gain, but i'm pretty sure i don't need a copy of some webpage i viewed a month ago.
http://www.downloadsquad.com/2009/03/31/firefox-slow-limit-history-size-for-speed-improvement?icid=sphere_blogsmith_inpage_downloadsquad
minibarAug 24th 2009 7:08PM
apparently, there's also an addon for this?
https://addons.mozilla.org/en-US/firefox/addon/13824
minibarAug 24th 2009 7:38PM
here's an improved version (good config) i tried.
https://addons.mozilla.org/en-US/firefox/addon/13878
Bryan PriceAug 24th 2009 9:35PM
Well, this seems to be working. But I had to do it for my installed 3.5.2, my portable 3.5.3 nightly, my portable 3.6 nightly, and my portable 3.7 nightly (what I'm responding with atm)
haoAug 25th 2009 10:27AM
Yeah its working great for me so far. :)
PeterSep 7th 2009 8:36AM
Thanks for this tip. FF is much faster now.
It took my places db from 70 Megs down to 3!!!