I want to boost the performance of spinning disks, was going to use Intel's software cache in conjunction with a Fusion-IO memory card (PCI SSD essentialy).
Before using the Fusion ioDrive as a cache, I wanted to see how fast my 110 gig database would restore.
Restoring to my RAID 10 spinning disks takes 2 hours, 57 minutes. Restoring to the Fusion-IO drive takes 2 hours, 7 minutes.
There is some improvement but not what I was expecting at all. Writes to the hard drive benchmark at 58 MB/sec and benchmark to the Fusion ioDrive benchmark at 811 MB/sec.
For such a massive difference in write speed, what reasons could there be that the SQL restore is so slow?!?!
I did a more extensive blog post about it if anyone wants more details:
http://wagamama.ca/old-technology-will-caching-help/
I think there has to be something wrong... I just don't know what.