[H-GEN] Speeding up Firefox (sqlite based apps)

[Ben Martin]

Also, for speeding up evolution...
http://www.advogato.org/person/robertc/diary.html?start=133

I didn't get much size decrease from the vacuum here, but I think the
reindexing helped a bunch. Without verification, I imagine that it
remade the index to be much closer block wise and thus gave a noticable
speed improvement for switching to a 50,000+ sized imap folder.

On Thu, 2010-08-19 at 10:03 -0400, Robert Brockway wrote:
> [ Humbug *General* list - semi-serious discussions about Humbug and     ]
> [ Unix-related topics. Posts from non-subscribed addresses will vanish. ]
> 
> On Thu, 19 Aug 2010, Russell Stuart wrote:
> 
> > Turns out it isn't so.  The reason sqlite3 was taking a while to search
> > those databases wasn't because they are particularly big.  It is because
> > they had became fragmented over time.
> 
> Hi Russell.  Thanks for pointing out this valuable advice.
> 
> The use of Sqlite has been causing other problems too, as people who have 
> NFS mounted home directories have been finding out.
> 
> > roughly as fast as the day you installed it.  Of course, if you think
> > firefox ran like a dog on the day you installed it then this isn't going
> > to help.
> 
> ;)
> 
> Cheers,
> 
> Rob
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.humbug.org.au/pipermail/general/attachments/20100823/aeed9ee3/attachment.sig>