One of the things that make relational databases so efficient is that they are optimized to run on a spinning magnetic disk (like a hard drive). They take time to know just where the head is located physically over the platter and move it in the most efficient manner. This isn't to say that they won't run faster on a solid-state memory device, just that you throw out a lot of hard work if you do.

I don't think this is a reason not to move to a solid-state storage device, just something to keep in mind. If you can justify getting a TB memory array for your application, go ahead.

I don't know if there is any real optimization you can do for solid-state devices, or if those optimizations will even make for a significant speed advantage.