Reply
Thread Tools
debernardis's Avatar
debernardis is offline debernardis
2009-07-15 , 13:15
Posts: 2,142 | Thanked: 2,054 times | Joined on Dec 2006 @ Sicily
#1
Linux needed: two rows of code may render your firefox much quicker:

Code:
cd .mozilla/firefox/*.default
for i in *.sqlite; do echo "VACUUM;" | sqlite3 $i ; done
It worked with mine

Taken here (there's also a firefox extension which does the same thing) - via Pollycoke
__________________
Ernesto de Bernardis
 
timsamoff's Avatar
timsamoff is offline timsamoff
2009-07-15 , 14:03
Posts: 1,605 | Thanked: 1,601 times | Joined on Mar 2007 @ Southern California
#2
I did this on my Mac as well by installing SQLite for OS X. Honestly, though, I can't see a huge difference. Maybe it works better in Linux...?

Tim
__________________
http://samoff.com
 
debernardis's Avatar
debernardis is offline debernardis
2009-07-15 , 17:42
Posts: 2,142 | Thanked: 2,054 times | Joined on Dec 2006 @ Sicily
#3
Mine seems quicker in url bar searching, as well as in starting. Can't rule out placebo effect of course, and didn't think of taking times before and after the dbase packing. However, it seems harmless
__________________
Ernesto de Bernardis
 
Bundyo's Avatar
Bundyo is offline Bundyo
2009-07-15 , 23:15
Posts: 4,707 | Thanked: 4,643 times | Joined on Oct 2007 @ Bulgaria
#4
It is harmless. The VACUUM command removes the empty space and fragmentation from an SQLite db, thus it loads quicker (though the actual access time should be roughly the same). Of course if there was fragmentation, the gains will be more noticeable.
 
Reply

« Previous Thread | Next Thread »
Thread Tools

 
Forum Jump


All times are GMT. The time now is 16:48.

Contact Us - Home - Archive - Top