Using Post Types Order with large databases

  • Resolved Tracy Maher

    (@kstpdigital)


    4 years, 1 month ago

    Has anyone tried using this plugin with a large number of stories? We have thousands in our database with multiple categories; though we will likely only need to use the plugin on the 10-20 most recently published stories at any given time.

    The page I need help with: [log in to see the link]

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

    (@tdgu)

    4 years, 1 month ago

    Hi,
    The plugin works with a large list of posts, still might take a while for the Re-Order interface to complete the load of data. Or you can use the WordPress default interface to change the order.

    Thanks

    Thread Starter Tracy Maher

    (@kstpdigital)

    4 years, 1 month ago

    Thanks for responding, Maya. We tested this early in our development process and found that because we ingest news stories from the Associated Press, the plugin was trying to reorder the list of posts every time that a post came in. That created a huge amount of traffic on the database and caused us to get “Unable to Connect to the Database” errors. Does your plugin offer customization options that would allow us to exclude the categories of Associated Press posts?

    davidarago

    (@davidarago)

    4 years, 1 month ago

    Hi Maya,
    I work with Tracy. The issue that we had when we were using the plugin is that we have processes that ingest post from other sources every 5 minutes. The plugin was attempting to sort the posts for every post that was created. That created an incredible amount of traffic on our database and we were getting “Unable to connect to the database” error messages. I think that if there is a way for the plugin to only update the post order of a category when all of the posts are inserted the plugin may work. Do you have a hook that we can call at the end of our process to trigger the category resorting?
    Thanks.

    Plugin Author Maya

    (@tdgu)

    4 years, 1 month ago

    Hi,
    I’m not sure where the problem is, but the plugin will not re-order anything on its own. If that happens, something else is triggering the sorting. Can you try to disable other plugins and see if there’s a change? It might be caused by a conjunction of codes after all.

    Thanks

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

The topic ‘Using Post Types Order with large databases’ is closed to new replies.