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

[Dennis Cote]

Ivan Voras wrote:

When using a file the difference is much smaller, but
still there: ~70 qps with sqlite3, ~90 qps with
sqlite2.
 

I also noticed that your values for this case are much higher than mine, 
which are 10 and 13 ips respectively. I realize that you are using a 
different OS (FreeBSD vs WinXP) but I was wondering if you had any 
special disk hardware that might account for some of this difference. 
Are you using fast SCSI disks or perhaps a RAID array?

Dennis Cote