SSD drives shouldn't be used for databases that are used for writes. This is because SSD drives only have limited number of writes before those segments start failing. Some of the higher cost SSD drives have "spare" space that starts getting used when the drives detect failed sectors but I wouldn't want to rely on it.
For operating systems, or read only databases, or for databases that aren't updated minute by minute, then the SSD would have a cost per performance advantage ... but ... for what we think of as database operations, I'd recommend using a faster HD. On 10/30/2011 08:25 PM, Malcolm Greene wrote: > Wondering if any of you have any personal experience using one of > the low cost SSD drives for database intensive work? > > I'm curious what your personal experience has been, eg. your > types of database activity, the type of improvement you noticed, > and what SSD products you recommend or don't recommend. > > Thanks! > Malcolm > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
