On Mon, Nov 5, 2012 at 5:04 PM, Theodore Ts'o <ty...@mit.edu> wrote: > On Mon, Nov 05, 2012 at 09:03:48PM +0100, Pavel Machek wrote: > > > Well, using data journalling with ext3/4 may do what you want. If you > > > don't do any fsync, the changes will get written every 5 seconds when > > > the automatic journal sync happens (and sub-4k writes will also get > > > > Hmm. But that would need setting journalling mode per-file, no? > > > > Like, make it journal data for all the databases, but keep normal mode > > for rest of system... > > You can do that, using "chattr +j file.db". It's apparently not a > well known feature of ext3/4.... >
Per the docs: "Only the superuser or a process possessing the CAP_SYS_RESOURCE capability can set or clear this attribute." That prevents most applications that run SQLite from being able to take advantage of this, since most such applications lack elevated privileges. > > - Ted > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users