I have a lot of friends using 'consumer grade' SSD for their DB workloads and the difference is night and day.
This might be a horrible example but my one friend had a installation of FileMaker Pro running on a completely tricked out XServer (RAID with 15K SAS drives). With 250 concurrent users he was completely max out on CPU and many queries took minutes to complete.
When he moved to a 256GB SSD his CPU load now never goes above 20% and not one query takes more than five seconds, period.
Also, please reference my old HN post from over a year ago.
Comments
I have a lot of friends using 'consumer grade' SSD for their DB workloads and the difference is night and day.
This might be a horrible example but my one friend had a installation of FileMaker Pro running on a completely tricked out XServer (RAID with 15K SAS drives). With 250 concurrent users he was completely max out on CPU and many queries took minutes to complete.
When he moved to a 256GB SSD his CPU load now never goes above 20% and not one query takes more than five seconds, period.
Also, please reference my old HN post from over a year ago.
http://news.ycombinator.com/item?id=1584998