[Plugin: SEO SearchTerms Tagging 2] SQL tweak

  • timbrd

    (@timbrd)


    14 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

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

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

    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Plugin: SEO SearchTerms Tagging 2] SQL tweak’ is closed to new replies.