* brian m. carlson: > On Mon, Feb 20, 2012 at 10:03:51AM +0100, Florian Weimer wrote: >> Have you tried setting "PRAGMA journal_mode = WAL" on the SQLite >> database, using the sqlite3 command line tool? > > Nope. I didn't know it existed. If it's needed for reasonable > performance, it should be set by default upon installation.
It prevents sharing the home directory over NFS on multiple machines at the same time. (PRAGMA synchronous = OFF) > I tried using this and patched the source code. It was ineffective. Then fsync performance isn't the issue. Unless the liferea database is really large, a couple of writes shouldn't have the impact you observe. So it's probably something else. > From what I saw when I last looked at the source code, it seems that > liferea uses sqlite very inefficiently, creating temporary tables and > such. Even if those tables are temporary, they still have to be added > to the database and committed. Not true, temporary objets are kept in a separate, in-memory database. > I have little experience with SQL or databases and even I know that > such behavior is extremely inefficient. You can't say that in general. -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
