> On modern PCs, SQLite's page cache does not have a large effect because > of the file cache of the OS, but you should do, e.g., > PRAGMA cache_size = -1000000; > for a 1 GB cache (default is only a few MB). Hitting the page cache is much cheaper as it does not involve a system call. Try opening a memory only db, versus placing sqlite on a ramdisk. A simple benchmark will show a large speed difference.
Sergej