Pagerank tools
[resolved] Missing Index (3 posts)

  1. Steve
    Posted 5 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


  2. Sven Wagener
    Plugin Author

    Posted 5 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!


  3. Steve
    Posted 5 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

  • Pagerank tools
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic