WordPress.org

Ready to get started?Download WordPress

Forums

SEO SearchTerms Tagging 2
SQL tweak (3 posts)

  1. timbrd
    Member
    Posted 3 years ago #

    Table wp_stt2_meta needs an index by 'last_modified', without it SELECTs like this one

    SELECT  <code>meta_value</code> ,  <code>meta_count</code> ,  <code>post_id</code>  FROM  <code>wp_stt2_meta</code>  ORDER BY  <code>last_modified</code> DESC LIMIT 50

    are going through all rows using expensive filesort.

    Without index:

    # Query_time: 0.007573  Lock_time: 0.000088 Rows_sent: 50  Rows_examined: 7882

    with index:

    # Query_time: 0.000334  Lock_time: 0.000076 Rows_sent: 50  Rows_examined: 50
  2. glhawk87
    Member
    Posted 3 years ago #

    I'm not sure what you're saying here I'm pretty much a noobie when it comes to coding. Do I need to change some of the code because this is eating up a lot of time?

  3. ovidiubica
    Member
    Posted 3 years ago #

    You are right, I've been searching the exact same thing as I have a lot of slow queries in my log from this plugin. Both random and latest incoming keywords suffer from slow database queries.

    I wonder what's the developer's opinion on this.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic