It is just changing the database from sqlite sqlite3. In previous versions Firefox stored this information in the worst possible format - Mork <http://en.wikipedia.org/wiki/Mork_%28file_format%29>. Format extremely complicated, barely machine readable that gave the users no possibility to parse the data (for a lot of laugh check out the specification on the Wikipedia page). This was finally replaced in the new Firefox by SQLite <http://sqlite.org/> - self contained, small footprint database.
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. In SQLite is the statement to do this called VACUUM;<http://www.sqlite.org/lang_vacuum.html> . In my case this effectively cut the size of urlclassifier3.sqlite and places.sqlite to half. Thus saving 20 MB in my memory and Firefox's speed improvement was very noticeable. So have fun with the vacuum cleaner Regards, anish** On Wed, Feb 18, 2009 at 2:41 PM, sahab <[email protected]> wrote: > > Works great. Thanks. Let me know the command explanation > > On Wed, Feb 18, 2009 at 2:31 PM, Anish .C <[email protected]> wrote: > >> *$ for f in ~/.mozilla/firefox/*/*.sqlite; do sqlite3 $f 'VACUUM;'; done* >> >> anish** >> >> On Wed, Feb 18, 2009 at 10:04 AM, Anish .C <[email protected]> wrote: >> >>> Guys try this >>> >>> 1. Close all firefox browsers >>> 2. open a Terminal >>> 3. enter the following >>> $> *for f in ~./mozilla/firefox/*/*.sqlite;do sqlite3 $f >>> 'VACUUM;';done* >>> >>> Run your browser again and check whether the issue is solved or not. >>> >>> Regards, >>> >>> anish** >>> >>> >>> On Tue, Feb 17, 2009 at 10:48 PM, Shino Jacob <[email protected]>wrote: >>> >>>> >>>> I did, you can try it. >>>> Another thing is firefox does have a memory leak. Memory allocated is >>>> not correctly reclaimed by os. >>>> >>>> On Tue, Feb 17, 2009 at 10:13 PM, Ashik S <[email protected]> wrote: >>>> > >>>> > I don't think so . :) did you go through the link i sent ? >>>> > >>>> > >>>> > > >>>> > >>>> >>>> >>>> >>>> -- >>>> Miles to go before I Sleep >>>> >>>> >>>> >> >> >> >> > > > -- > Turn to Linux.................. > http://sahabm.blogspot.com > > > > > --~--~---------~--~----~------------~-------~--~----~ "Freedom is the only law". "Freedom Unplugged" http://www.ilug-tvm.org You received this message because you are subscribed to the Google Groups "ilug-tvm" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For details visit the website: www.ilug-tvm.org or the google group page: http://groups.google.com/group/ilug-tvm?hl=en -~----------~----~----~----~------~----~------~--~---
