Great post by Pythian’s Gwen Shapira explaining different aspects of SSD:
SSD is fast for reads, but not for writes. Its fast for random writes, but not for sequential writes. You shouldn’t use it for redo, except that Oracle do that on their appliances. SSD gets slow over time. SSD has a limited lifespan and is unreliable. Performance depends on exactly which SSD you use. You can have PCI or SATA or even SAN. You can use SSD for flash cache, but only specific versions, maybe. You can have MLC or SLC. It can be enterprise or home grade.
Remember that storing your data shouldn’t be a black-and-white decision on using RAM vs SSD vs spinning disks.
Original title and link: De-Confusing SSD ( ©myNoSQL)