Permanently deleting trash takes forever

I tried it out on several of my test sites and couldn’t recreate this problem. We only perform any processing on delete if the post was originated by MyCurator (ie Made Live from the training posts) or is a Training Post. Try deleting some regular posts (drafts) that you create and have nothing to do with MyCurator. See if they take as long.

If not, we do two things on the delete. First, if it is a MyCurator originated post or training post, we remove any images from the media library that are associated with it. We use standard core WP functions to do this so I can’t imagine this being a problem.

Next we have to delete the saved page text from a separate file – wp_sl_pages. Using phpmyadmin you could check and make sure that this file has an index on the field sl_post_id. If that index was gone, it could slow down the delete.

mtilly, you’re a treasure, your replies are faster than thunder.
I have same good and some bad news.
The good ones are that either deleting MC trash or WP trash it takes the same long time.
I should have noticed it before bothering you but normally I do not trash normal posts in WP trash so only the MC trash gets filled up.
The bad ones are that I’ll have to dig deep to isolate the root of the problem.

Now, while searching for the problem I noticed that my wp_sl_pages holds ~1000 records – why?. I’ve checked that records are deleted when MC trash is emptied, but they are not when a training post is made live. So correct me if I’m wrong but shouldn’t it also delete the original pages in sl_pages?
In case I’m mistaken then how is this table maintained from forever growing?
Is it ok to manually empty this table with no implications?
Thank you Thank you

PS I am marking this as resolved and when and if I discover the root of the problem I’ll inform you accordingly.

Yes, we do keep the full text after the post is live. This file will only grow with your live posts, and most hosts give you plenty of space for files. It is also indexed so it will not slow anything down, and is not used on your live site so won’t impact your page load for visitors.

We’ve kept the full article text around because you may want to edit the post in the future and have access to the original article text.

Also, web pages are always disappearing. One of our development projects is to look at replacing your link to the original web page if it disappears with a link to this ‘Readable Page’. That way your post can still reference the article and display it even if the original gets taken down.

We will also investigate an option to remove saved pages from the file for live posts for those who would like to.

Great mtilly.
Isolated the problem by disabling (temporarily while emptying trash) the wysija plugin. Will address the problem to its authors…

I also had this problem, and cured it by disabling Wysija. I have the premium version, and will also contact them.