Re: [sqlite] Disk I/O utilization

2016-12-12 Thread Quan Yong Zhai
-users@mailinglists.sqlite.org<mailto:sqlite-users@mailinglists.sqlite.org> 主题: [sqlite] Disk I/O utilization Our application does a lot of SQLite read/write in a background process. On some environments this hammers the disk I/O (e.g. Task Manager -> Disk). Do you have suggestions on how we might minimize

Re: [sqlite] Disk I/O utilization

2016-12-12 Thread Keith Medcalf
On Monday, 12 December, 2016 18:24, Vince Scafaria wrote: > Our application does a lot of SQLite read/write in a background process. > On some environments this hammers the disk I/O (e.g. Task Manager -> > Disk). Do you have suggestions on how we might minimize this? >

Re: [sqlite] Disk I/O utilization

2016-12-12 Thread Simon Slavin
On 13 Dec 2016, at 1:23am, Vince Scafaria wrote: > Our application does a lot of SQLite read/write in a background process. On > some environments this hammers the disk I/O (e.g. Task Manager -> Disk). Do > you have suggestions on how we might minimize this? Batch them

[sqlite] Disk I/O utilization

2016-12-12 Thread Vince Scafaria
Our application does a lot of SQLite read/write in a background process. On some environments this hammers the disk I/O (e.g. Task Manager -> Disk). Do you have suggestions on how we might minimize this? Perhaps related, one operation that seems to use a lot of the Disk I/O is when we use