On Mon, May 05, 2014 at 05:00:08PM -0400, Richard Hipp wrote: > On Mon, May 5, 2014 at 4:53 PM, Patrick Donnelly <batr...@batbytes.com>wrote: > > > Hi, > > > > I have an INSERT that looks like > > > > INSERT INTO T > > SELECT ... > > > > which I'm running numerous times a second that generally does nothing > > because the SELECT returns no rows. Unfortunately, I've found that > > SQLite still does numerous disk writes anyway in this situation. > > > > I'm unable to reproduce this behavior. Here is my test script: > > .... > No writes. >
I suspect the culprit is file access time updates. Using something like relatime mount option under Linux would eliminate atime updates for files that have not been modified. Christian _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
