I believe I have some plugins that are terribly ineffective (such as recent comments, top commenters, among others).
However, these plugins are ESSENTIAL to the functionality of my site, and what the readers want and use.
What can be done to make a particular plugin LESS of a SQL hog?
- Can indexes be created in MySQL to improve query performance? If so, how?
- Is there a company/person/service that can re-write a particular plugin for you? What is the cost?
- How can I find exactly which of my plugins are causing the MOST damage to my CPU % usage? What are the most expensive?
Any other ideas?
I've done EVERYTHING to speed up site.. you name it (wp-cache, eAccelerator, query caching, Varnish HTTP proxy caching, and MORE)...
It's coming down to either DB tuning, or bad code in my site that needs re-writes...
Thank you very much in advance.