RE: [sqlite] SQLite :memory: performance difference between v2 and v3?

aches rather than OS filesystem buffers (and avoid the double-caching effect). I don't know if you can force a database to be opened with O_DIRECT though in sqlite. Your hard drive usually has a read-ahead cache too, so that also can interfere with true disk-bound benchmarking. Best regards,

RE: [sqlite] questions about performance

- thus avoiding "dual caching" of MySQL data files. Best regards, Richard Dale. Norgate Investor Services - Premium quality Stock, Futures and Foreign Exchange Data for markets in Australia, Asia, Canada, Europe, UK & USA - www.premiumdata.net

RE: [sqlite] questions about performance

Command queuing such as some SATA and pretty much all SCSI drives), increased RPMs and more on-board cache. Best regards, Richard Dale. Norgate Investor Services - Premium quality Stock, Futures and Foreign Exchange Data for markets in Australia, Asia, Canada, Europe, UK & USA - www.premiumdata.net