The best devices for this kind of use are probably the newer sorts of hybrid hard disc that include some flash
memory which acts as a front end I/O cache for the rotating hard disc; the disc needs to mechanically spin less
because some of the I/O is taken care of by the integrated non volatile flash memory.
I've no idea what the cost effectiveness of these presently are, though, they're pretty new, and not all that commonly
used yet.