SSDs aren't necessarily faster than disks: http://en.wikipedia.org/wiki/Solid-state_drive#Disadvantages
----- Original Message ----- From: "Mark" <godef...@gmail.com> To: <sqlite-users@sqlite.org> Sent: Monday, September 21, 2009 1:53 PM 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
