*** 1,6 **** --- 1,9 ---- This page is about using in-memory SQLite databases. ---- + 2007-04-16: I have run a simple test to compare the performance of disk-based database and memory-resident database in sqlite3, the result was the same as the wiki item at 2006-09-08 said. Why the memory-resident database is so slow? Is there any way to improve it? + + ---- 2006-09-08: It appears that if you're doing a small number of transactions, that in-memory vs. on-disk doesn't make much difference. I have 138000 rows to insert, and as long as I do them all inside of one transaction, the run time is pretty much the same. However, if I don't use any transactions and just do a bunch of inserts, then the on-disk db is horribly slow compared to memory. Check out the note about transactions in PerformanceTuning. 2006-10-31: That's all quite relative to disk speed. For example, I'm writing an app that runs off of flash memory and the difference in speed is quite noticeable even with a single insert.
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|