July 13, 2010
Is your Liferea 1.6.2 Getting Somewhat Slow?

Because mine was. I’m running Liferea for some months, with lots of feeds, and I’ve noticed lately that it was getting slower. I couldn’t say how much, but it was noticeable.

I’ve tried to unfragment the database:

$ cd ~/.liferea_1.6
$ cp liferea.db bak.db
$ sqlite3 liferea.db VACUUM;

My liferea.db was 18MB before the VACUUM and 15MB after, but the point is that I’ve noticed it’s faster starting and updating the feeds after the surgery.

Once you run Liferea and everything’s OK, you can remove the bak.db.

by jjm on 2:49pm  |   URL: http://tmblr.co/ZPorZym4fQf
(View comments) 
Filed under: Liferea Fedora sqlite VACUUM 
April 21, 2010
"SQLite library consists of approximately 67.2 KSLOC of C code. (KSLOC means thousands of “Source Lines Of Code” or, in other words, lines of code excluding blank lines and comments.) By comparison, the project has 679 times as much test code and test scripts - 45678.3 KSLOC."

—

From How SQLite Is Tested, via Reddit.

Impressive. In comparison, Perl 5.12.0 has 29826 tests*.

* from running egrep -ri "tests ?=> ?" * | perl -e '$s = 0; while(<>) { m/.*tests ?=> ?([0-9]+)/; $s+=$1;} print "total: $s\n"' inside t/ directory. Remember Tumblr RSS is broken, you may not see the right code in your feed reader.

by jjm on 8:17am  |   URL: http://tmblr.co/ZPorZyW3Nm2
(View comments) 
Filed under: Tests Quality SQLite Perl KSLOC