Bulk deletes cause memory issues with server

  • Resolved TheMann00

    (@themann00)


    7 years ago

    Trying to clear out lots of old events. About 15,000.

    Doing 20 at a time through the WordPress backend is annoying enough, but I had to raise my memory allocation in php.ini from 128M to 512M to even get through the 20. Otherwise it did what it could before timing out.

    Then emptying the trash….. I raised my memory allocation to 1024M, and get about 600 out at a time before it times out.

    So then I went into phpMyAdmin, and was able to delete 15,000 records in 0.33 seconds. With no memory issues. However, the plugin backend still thinks they are all there. (sql delete from wp_em_events, I think)

    Why does this simple admin task destroy my memory?

    And what sql command can fully delete as I want to do?

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

Viewing 1 replies (of 1 total)
  • Plugin Support angelo_nwl

    (@angelo_nwl)

    in the table wp_em_events there is a post_id which is equivalent to the post_id in the table wp_posts which you also need to be deleted since EM is using wp custom post type as well

Viewing 1 replies (of 1 total)
  • The topic ‘Bulk deletes cause memory issues with server’ is closed to new replies.