Timeout when removing deleted posts (in Trash)

  • Hello,

    I’m cleaning a site with 60,000 WooCommerce products.

    I’ve tried to delete products from the same brand, which they were about 5,000 and plugin was only able to remove from trash in groups of 200 approximately.

    I wonder if it could be improved.
    On server side I did increase set_time_limit to the maximun available, and I did also increased memory limit.
    But I do not know what else I can do.

    Probably the only way it would be deleting via WP-CLI, wouldn’t it?

    Many thanks.

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

    (@gamerz)

    CLI or keep running it. It is safe to do so. I think you should time how long it takes. It is weird that you change it and it still deletes 200.

    Thread Starter Jairo Ochoa

    (@jairoochoa)

    Hi @gamerz

    Yes, I was also thinking of WP-CLI

    The shop manager do not have SSH access so he can only use plugins and he is used to work with WP-Sweep but in this case I will have to do it for him.

    Yes, if run the Delete and wait for minutes, when reloading the page we see that there are about 200 product less.
    Notice that Delete must find any product which post_status is “trash” and it needs to follow up 60000 products.
    Probably this is the reason of the timeout

    Regards

    Plugin Author Lester Chan

    (@gamerz)

    But if you set the time limit to 0, it should not time out though.

    Thread Starter Jairo Ochoa

    (@jairoochoa)

    Well, I’ve increased the time limit to the maximum available by the hosting.
    Finally I will use WP CLI to do it.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Timeout when removing deleted posts (in Trash)’ is closed to new replies.