[Gajim-devel] Improve loading of roster items

[Genghis Khan]

On Fri, 21 Feb 2014 06:46:08 +0100
"Genghis Khan" <genghiskhan at gmx.ca> wrote:

> 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.
> 

Disk I/O rate was 200 K/s (write).

K as Kilobytes.

> 
> 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>