Hi Mark I've had a little experience working with flash-based filesystems - I'd recommend playing with the page_size and temp_store PRAGMAs (and of course make sure you are using transactions to minimise the number of file writes) to improve performance.
Cheers, Dave. -----Original Message----- From: Mark [mailto:godef...@gmail.com] Sent: 21 September 2009 13:54 To: sqlite-users@sqlite.org Subject: [sqlite] SQLite database on a certain high-performance "SSD" I've currently got a loaner high-performance flash-based "SSD" (let's just say it doesn't connect to any disk controllers) that I'm testing for performance. I've run my application against it, and I believe that I should see numbers MUCH higher than I do. When I run my test app on a normal SATA 7200 RPM disk, I get a certain performance, and on the "SSD" I get about 1/10th that speed. On an array of SAS disks I get numbers that are about 5x faster than my SATA disk, so my software itself isn't (I believe) the bottleneck. I'm wondering if anyone has any tips for "optimizing" for this sort of storage solution. Also, if anyone has any quick-and-dirty test setups they'd like me to run through on this rig, just let me know :) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users