How is the SSD connected? Could it be an issue with the transport layer to the device?
--- On Mon, 9/21/09, Dave Toll <dave.t...@opentv.com> wrote: > From: Dave Toll <dave.t...@opentv.com> > Subject: Re: [sqlite] SQLite database on a certain high-performance "SSD" > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Date: Monday, September 21, 2009, 5:31 PM > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users