4 ms·
A lot of your woes would be solved by in memory caching.
by kintamanimatt 13y ago
A lot of your woes would be solved by in memory caching.
- jacques_chester 13y agoIf it's a LAMP app, then not really. If you have tables with TEXT fields, MySQL up to and including 5.5 will perform certain joins with on-disk tables no matter what you tell it to do and will ignore indexes you create to prevent that on-disk stupidity. This behaviour is independent of engine. Being I/O choked on Linode is why I moved to DigitalOcean.
- ceol 13y agoIt sounds like you should have moved from MySQL to PostgreSQL instead of switching hosting providers.
- jacques_chester 13y agoPlease call me when Wordpress and thousands of plugins and themes have been expunged of all MySQLisms. Otherwise, heartily agreed.
- ceol 13y agoAhh, Wordpress. You have my deepest sympathies. If you don't mind my asking, is there some key feature of Wordpress or its plugins that holds you to it? I'm always interested to hear why people stick with it.
- jacques_chester 13y agoI personally detest it. But my bloggers are comfortable with it.