Sean’s Mental Walkabout

I found that Liferea (my rss reader) was starting to get really slow. Hitting space bar to go to the next article was getting somewhat painful levels of delay.

The Fix

Liferea uses sqlite to store it’s information. Over time, when you delete from sqlite, the db gets pretty unoptimized (lots of tombstones). This can be fixed with the following command (make sure Liferea is NOT running before doing this):

sqlite3 ~/.liferea_1.4/liferea.db vacuum

(adjust the directory if running a different version of liferea.) It both made my liferea.db 1/2 as big, and now everything is snappy again.

Popularity: 19% [?]

This entry was posted on Sunday, July 20th, 2008 at 1:26 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.