Increasing the sqlite cache size seems to have improved it for me:
$ sqlite3 /home/stewart/.liferea_1.4/liferea.db
SQLite version 3.6.10
Enter “.help” for instructions
Enter SQL statements terminated with a “;”
sqlite> pragma default_cache_size=20000;
Ramblings
Ramblings which occasionally resemble reality. This is the blog of Stewart Smith.
Try Liferea 1.6 — greatly improves performance over v1.4.
Pingback: Francois Marier (fmarier) 's status on Friday, 18-Sep-09 04:17:42 UTC - Identi.ca
Will be great when it hits the Ubuntu package archives (or I upgrade to 9.10 I guess… hoping it’s there)
Stewart,
Just add the Liferea PPA if you are on Jaunty. :-)
Take a look here:
http://webupd8.blogspot.com/2009/07/liferea-first-16x-stabe-version-how-to.html
ooerrr….. Will give it a go
does seem faster. yay!
Let us know how you get on. Imports 1.4 feeds into Liferea seamlessly… :)
Saying that — you can still use the ‘default cache size’ trick. :D
Ahh goodie! :) (Seems my last post crossed yours in transit!)
Yeah, I haven’t looked back since going to 1.6.x :)
It still gets fairly sluggish… even with the cache size set to 20000 and using 1.6. It’s also fairly crashy now :(
I was getting very heavy disk grinding from Liferea, and I’ve been experimenting with various settings for sqlite, based on Stewart’s tip here. I didn’t personally find much difference with increasing the cache size, but it made a HUGE difference to set the synchronous mode to NORMAL instead of the default FULL.
As above:
$ sqlite3 ~/.liferea_1.6/liferea.db
SQLite version 3.6.10
Enter “.help†for instructions
Enter SQL statements terminated with a “;â€
sqlite> pragma synchronous=1;
sqlite> ^D
$
There’s a very slight increase in the possibility of database corruption if a power failure were to happen in the middle of an update, however it seems well worth the risk to me, and hopefully saves my hard drive!
the synchronous pragma is only per session and won’t be saved in the db:
stewart@willster:~/$ sqlite3 ~/.liferea_1.6.db erea.
SQLite version 3.6.16
Enter “.help” for instructions
Enter SQL statements terminated with a “;”
sqlite> pragma synchronous;
2
sqlite> pragma synchronous=1;
sqlite>^d
stewart@willster:~/drizzle/embedded-innodb/tests$
stewart@willster:~/$ sqlite3 ~/.liferea_1.6/liferea.db
SQLite version 3.6.16
Enter “.help” for instructions
Enter SQL statements terminated with a “;”
sqlite> pragma synchronous;
2
sqlite>
Good point. There is a default_synchronous setting that makes it permanent. I set mine to default_synchronous=0 (off) and it has radically improved the update and viewing speeds.
Update: apparently the default_synchronous setting was removed in SQLite3. I’m now considering either starting Liferea with a script that sets the pragma each time, or setting it in Liferea code and recompiling….