John Stanton wrote:
Cacheing will drive you crazy.

Very well put.

Most of SQLite's disk I/O is actually going to the memory used for the operating system's disk cache, not directly to the disk. Hence its speed is not much different when using a disk based database than a memory based database. I'm still a little surprised that a disk based database is actually slightly faster than a memory based one, but that just means that SQLite's memory based page I/O is less optimized than the OS's file I/O libraries.

Dennis Cote

Reply via email to