[Gajim-devel] Improve loading of roster items

[Genghis Khan]

Hello,


There is a problem with Gajim which, I suspect, is related to SQLite
file cache.db.

"Gajim isn't exactly solid when it comes to Window objects writing.
It takes it 10 minutes to load a roster with 250 entries while with
Swift it takes maybe 5 seconds." --written by an XMPP server admin.

It was reported to me that Disk I/O rate is at 200 K/s while occurs.


Liferea, a GTK+ Feed Reader, used to have a problem which manifested in
freezing UI while scanning feeds.

Since Liferea 1.8.3 (released on March 23rd 2012), the feed scanning
process has has improved performance by 60 times, due to lower Disk I/O
rate resulted by utilising sqlite3 3.7+ WAL journaling[0]. However, due
to the use of WAL journaling, a new problem[1] emerged which caused to
database file liferea.db-wal to grow to a ridiculous size, and later
fixed[2] by Sven Hartge in Liferea 1.8.6[3].

* I think that the file liferea.db-wal got radically big, especially,
  in NFS file-systems, but that problem was fixed for any file-system.

[0]: http://sourceforge.net/mailarchive/message.php?msg_id=29029130
[1]: http://sourceforge.net/mailarchive/message.php?msg_id=29183881
[2]: http://sourceforge.net/mailarchive/message.php?msg_id=29412284
[3]: http://sourceforge.net/mailarchive/message.php?msg_id=29412285


Regards,
--GK.

-- 
Defending the constitution is expensive!
Help Lavabit.com by donating to the Lavabit Legal Defense Fund
http://lavabit.com/ <support at lavabit.com>