Support » Plugin: Delete Duplicate Posts » 0 duplicates found

  • Resolved scarfatio

    (@scarfatio)


    Hi. I need help with your plugin. I have a blog of about 400,000 posts and if I try to look for duplicates with your plugin I only get what you see from the screen that I am attaching, that is 0 results. There are actually thousands of duplicate posts. I tried to look for only 50 but it doesn’t change the result
    https://ibb.co/RYV4X5f
    My website use WordPress 6, php 8.1 and vps hosting.
    Thanks
    Ivan
    These are the logs
    2022-06-23 12:39:20 Look up error: MySQL server has gone away
    2022-06-23 12:39:20 0 duplicates found in 420.028 sec. Mem usage: 20 mb

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Lars Koudal

    (@lkoudal)

    Hello @scarfatio – that sounds like your server times out. From the screenshot it seems you have about 450.000 posts. I have not tested with that amount of posts, but I will try to add more posts and see if I can improve the SQL query to detect the duplicates with that amount of posts to compare.

    Thread Starter scarfatio

    (@scarfatio)

    I’ve tried all sorts of ways. I also got the premium version but the plugin unfortunately always releases that error. (MySQL server has gone away) I can’t understand why until a month ago it worked very well and was very fast. 🙁

    Thread Starter scarfatio

    (@scarfatio)

    I have a simple idea. Insert the possibility to select the articles, as well as by published, also by category or date. In this way the load on the database is less.

    Plugin Author Lars Koudal

    (@lkoudal)

    Good idea, but I think that would add more complexity to the database SQL queries, so it could perhaps slow it down even more.

    I am creating a test site to match the 400K posts to test on, so far testing at 200K works fine and returns results in a few seconds. Could it be there is some other plugin that adds to the queries? Best approach if possible is to deactivate all other plugins and/or the theme and then see if the plugin still times out.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘0 duplicates found’ is closed to new replies.