Making Plugins More Efficient

  • 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.

Viewing 5 replies - 1 through 5 (of 5 total)

  • Is there a company/person/service that can re-write a particular plugin for you? What is the cost?

    Cost aside (no bidding here, see Forum Rules, section F):
    – you can post here with a contact address requestiong paid support; the hread will be closed
    – post to the wp-pro list:
    https://lists.automattic.com/mailman/listinfo/wp-pro

    Hmm from what I think “such as recent comments, top commenters” can’t be cache because they suppose to be real time. It also depends on your complexity of your queries and the server hosting your site/db

    Thread Starter southbeach030

    (@southbeach030)

    How can I find the proper way to ensure that (at the very LEAST) I have indexes in the proper places?

    myphpadmin indicates that I may not have the proper indexes, since I have a lot of full_joins taking place…

    Select_full_join 295
    The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.

    Thread Starter southbeach030

    (@southbeach030)

    in other words.. with the “recent comments” and “top commenters”, etc.. what kind of index should I create?

    Can anyone please share a quick walk-through on how I could test this out?

    Thank you!

    Thread Starter southbeach030

    (@southbeach030)

    Here’s an example of a slow query (25 seconds)… it seems as if it’s the “recent comments” plugin, but I cannot be 100% sure.

    Can anyone suggest an index (in either wp_posts or wp_comments) that might speed up this query?

    I’ve done everything possible under wordpress (caching, sql query cache, opcode cache, and more)..

    # Query_time: 25 Lock_time: 0 Rows_sent: 15 Rows_examined: 72625
    SELECT wp_posts.ID, post_title, post_name, post_date,
    COUNT(wp_comments.comment_post_ID) AS ‘comment_total’ FROM wp_posts LEFT JOIN wp_comments ON wp_posts.ID = wp_comments.comment_post_ID WHERE comment_approved = ‘1’ AND post_date_gmt < ‘2007-07-30 13:42:54’ AND post_status = ‘publish’ AND post_password = ” GROUP BY wp_comments.comment_post_ID ORDER BY comment_total DESC LIMIT 15;

    Thanks again in advance.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Making Plugins More Efficient’ is closed to new replies.