Tip & How-To about Mozilla Firefox

Speed Up Firefox loading times by defrag of the places.sqlite

Having database store your browsing data has one drawback, you have to optimize the database from time to time to get rid of old, deleted data, re-index the columns etc.Otherwise you keep all the junk data mixed in with your real data.

Over a period of time your places.sqlite database will fill with data of your browsing history this will cause the loading of Firefox to become sluggish even on fast PC's it almost appears to freeze and make you wanna go back to IE8 or to Chrome it don't use this Tip and stay with Mozilla.



There are several solutions the easiest is to rename the places.sqlite file to places.sqlite.bak and if you need to open this file and save any of your history links you can use Nirsoft's excellent MozillaHistoryView you will have to select the Application Data folder manually in order to edit this file this one has almost 8,000 entries and is over 3MB in size.

If you want to do this automatically there is an XPI add-on called Vaccum Places that you can set to do this for you I prefer removing the file every month of so and using the viewer to save any websites that you might need




To activate the sqlite defragmentation goto the tools and click the last entry Vacuum places.sqlite and you will receive confirmation in the lower right hand corner of the desktop you will see a marked improvement in the cold start of firefox, you can set this to automatically do this after a specified number of starts I find 30 to be a good number.

Remember this will not remove entries but place them in order to make firefox faster so if you use the Nirsoft viewer you will still have the same number of entries just in a better order.



You can also set the history to only keep a few days history, 90 days is the default which is too long you can get away with 20 or so quite easily use the settings in the Firefox browser to do this.



You will notice a huge speed up on the loading of your Firefox from several minutes to a few seconds using a combination of the Vacuum XPI and reduced browsing history settings.

If you want to compress this sqlite database and remove a possible bug caused by Google toolbar bloating the dB then use this free software you will have to unzip the archive into you own profiles folder and then browse for the places.sqlite file create a backup prior to doing this




You will need to find the default Firefox profile and make a backup copy of the places.sqlite file access this using the following command from the run prompt




http://www.conceptworld.com/Free/CompressSqliteDatabase.zip


Happy Faster Firefox-ing you can reduce your database down by about 10% removing all the Google toolbar entries using this compression from RECENTX and speed up your Firefox loading time I used this then uninstalled the google toolbar didn't use it anyhow.

There are also 4 more XPI add-ons that will do this however I prefer the Vacuum Improved one



The SQLite Optimiser XPI as well as the Vacuum function has the added indexing function which also speeds up the loading times the result should look like this.



Posted by on

Mozilla Firefox Logo

Related Topics:

Related Questions:

1 Answer

How do you empty the sentbox in incredimail?


?

A: The 'Deleted Items' folder contains the email messages deleted from your other folders. It is recommended that you empty the 'Deleted Items'folder from time to time, to avoid the build up of old and unnecessary email, which may slow down your email environment.

To empty the 'Deleted Items' folder, simply right-click the folder and select 'Empty 'Deleted Items' Folder'. If the 'Deleted Items' folder is not emptied, please follow these steps:
  1. Right-click the IncrediMail Tray Icon (orange envelope), located in the lower right corner (near the computer clock), and select 'Exit'.
  2. Windows 2000 or XP users: Browse to the following location:

    C:\Documents and Settings\Your Profile(Logon Name)\Local Settings\Application Data\IM\Identities\{Long Number}\Message Store



    Windows 98 or ME users: Browse to the following location:

    C:\Windows\Application Data\IM\Identities\{Long Number}\Message Store
  3. Delete the 'Deleted Items.imm' and the 'Deleted Items.imh' files.
  4. Open IncrediMail. Next time you wish to empty your 'Deleted Items' folder, simply right-click the folder and select 'Empty 'Deleted Items' folder'.

Sep 29, 2016 | IncrediMail

3 Answers

How do I clean my cache


As you surf the Web and enter log in information, some sites store your personal information in files called cookies.


Cookies save your log in data so that you don't have to enter the information each time you visit a site.


In addition, some sites save site data such as images and documents in your browser's cache.


These temporary files can speed up the time it takes to visit the website in the future.

If you want to get rid of cookies and cache data, you can do so by following a few steps.


Open Internet Explorer and select "Safety" on the toolbar.


Select "Delete Browsing History..." and select the boxes next to "Cookies" and "Temporary Internet Files."


Click "Delete" to clean your cache and cookies.


Firefox


Open Firefox and select the "Tools" menu. Click "Clean Recent History."


Select "Everything" from the drop-down menu next to "Time Range to Clear."

Select the boxes next to "Cache" and "Cookies" in the list below "Details."


Click "Clear Now" to erase your cache and cookies.


Google Chrome


Open Google Chrome and click the "Wrench" icon to the right of the address bar.


Select "Options" and click the "Under the Hood" tab. Click "Clear Browsing Data" under "Privacy" and select the boxes next to "Empty the Cache" and "Delete Cookies and Other Site Data.

" Select "Everything" from the "Clear Data From This Period:" drop-down menu.


Click "Clear Browsing Data" to empty your cache and delete your cookies.


Hope this helps.




Nov 19, 2012 | Compaq Presario CQ56-115DX Laptop

1 Answer

how to change age?


I'm assuming you entered the wrong age whilst viewing a website.

The easiest way is to clear the cookies stored in the browser.
By doing this it will get rid of all of the cookies that were stored by websites.

Press CTRL+SHIFT+DEL then untick all the boxes except 'Delete cookies and other site data'
Also change the dropdown to roughly around the time you entered the wrong age infromation.
Then click 'clear browsing data' and it should work.

May 02, 2011 | Google Chrome

2 Answers

Need to reboot!My browser is too slow


if you are using internet explorer
all you have to do is go to tool>internet options> the advance tap
and then go to the bottom and click reset

Mar 03, 2011 | Compaq Presario CQ62-215DX Laptop

Not finding what you are looking for?

502 people viewed this tip

Ask a Question

Usually answered in minutes!

Top Mozilla Computers & Internet Experts

Lesley Cameron
Lesley Cameron

Level 3 Expert

371 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18394 Answers

k24674

Level 3 Expert

7993 Answers

Are you a Mozilla Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Loading...