SSDs are not a fix to bad coding, lack of RAM, poor configurations, etc. It can and will help on fresh, mostly empty drives though.
Optimization should be done to your site / web projects first. Proper database indexes, table design, etc. Tune queries - get a DBA for an hour or two to do...