Logger fsyncs on every message in Linux
Problem
OS: Linux
Every message in regular chats (have not checked with multi-user chats) causes logger to perform fsync on some temporarily created file (logs.db-XXXXX). This takes from 70 to 100 msec on different machines, causes slight delays in responsiveness and spins up the disk.
Analysis
The cause seems to be the logger setting isolation level = IMMEDIATE on sqlite.connect. Setting the isolation level to default DEFERRED fixes the problem. IMMEDIATE seems unnecessary for present case as Gajim running instance is the only writer to the logs database (is this correct?)
Enhancement recommendation
Remove the isolation level from sqlite.connect.