WordPress.org

Ready to get started?Download WordPress

Forums

Pagerank tools
[resolved] Missing Index (3 posts)

  1. Steve
    Member
    Posted 3 years ago #

    My mysql slow log query is showing a lot of the following:

    SELECT * FROM wp_1_prtools_url WHERE lastupdate<1288258725 OR (lastupdate<1290418725 AND pr=-1) ORDER BY lastupdate LIMIT 0,5;

    You're missing an index on lastupdate

    http://wordpress.org/extend/plugins/pagerank-tools/

  2. mahype
    Member
    Plugin Author

    Posted 3 years ago #

    Hi Steve,

    i cant follow. What do you mean?

    Sorry for my late answer. At the moment I'm programming a pro version which is 99% ready. Maybe it will interest you ;)

    Thank you for your efforts!

    Sven

  3. Steve
    Member
    Posted 3 years ago #

    I mean that you're missing an index on the table which means that the queries run against it have to full table scan to get the data.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic