Thanks for your fast response On Wed, Feb 18, 2009 at 2:47 PM, Anish .C <cani...@gmail.com> wrote:
> 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 <sahab...@gmail.com> wrote: > >> >> Works great. Thanks. Let me know the command explanation >> >> On Wed, Feb 18, 2009 at 2:31 PM, Anish .C <cani...@gmail.com> wrote: >> >>> *$ for f in ~/.mozilla/firefox/*/*.sqlite; do sqlite3 $f 'VACUUM;'; done >>> * >>> >>> anish** >>> >>> On Wed, Feb 18, 2009 at 10:04 AM, Anish .C <cani...@gmail.com> 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 <shinoja...@gmail.com>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 <aash...@gmail.com> 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 >> >> >> >> > > > > -- 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 ilug-tvm@googlegroups.com To unsubscribe from this group, send email to ilug-tvm-unsubscr...@googlegroups.com For details visit the website: www.ilug-tvm.org or the google group page: http://groups.google.com/group/ilug-tvm?hl=en -~----------~----~----~----~------~----~------~--~---