Re: [PERFORM] SSD database benchmarks

2008-04-29 Thread Merlin Moncure
On Tue, Apr 29, 2008 at 2:55 PM, Greg Smith <[EMAIL PROTECTED]> wrote: > This is the best write-up I've seen yet on quantifying what SSDs are good > and bad at in a database context: > > http://www.bigdbahead.com/?p=37 > > -- > * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, M

Re: [PERFORM] SSD database benchmarks

2008-04-29 Thread Greg Smith
On Tue, 29 Apr 2008, Guido Neitzer wrote: They totally missed "mainly write" applications which most of my applications are. Not totally--the very first graph shows that even on random data, 100% write apps are 1/2 the speed of a regular hard drive. After poking around the site a bit more t

Re: [PERFORM] SSD database benchmarks

2008-04-29 Thread Guido Neitzer
On 29.04.2008, at 12:55, Greg Smith wrote: This is the best write-up I've seen yet on quantifying what SSDs are good and bad at in a database context: http://www.bigdbahead.com/?p=37 They totally missed "mainly write" applications which most of my applications are. Reads in a OLTP setup a