Making Plugins More Efficient (6 posts)

  1. SouthBeach030
    Posted 9 years ago #

    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.

  2. moshu
    Posted 9 years ago #

    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:

  3. Lester Chan
    Posted 9 years ago #

    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

  4. SouthBeach030
    Posted 9 years ago #

    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.

  5. SouthBeach030
    Posted 9 years ago #

    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!

  6. SouthBeach030
    Posted 9 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic