[sqlite] Backing up SQLite DB with unbuffered I/O

2015-10-29 Thread Clemens Ladisch
Eric Grange wrote: > Is there a way to perform an online backup with unbuffered I/O? A tool like ionice changes the I/O priority, which is something different. You would have to modify SQLite, or write your own VFS. Regards, Clemens

[sqlite] Backing up SQLite DB with unbuffered I/O

2015-10-29 Thread Eric Grange
Is there a way to perform an online backup with unbuffered I/O? I am currently performing backups with the command-line tool and ".backup", but this appears to wreak havoc on the OS disk cache. I am able to mitigate this by disabling buffering on the destination drive, but that cannot be used for