I import and delete around 3 million job postings per week on my website: salarship.com
I really need to get the deleting part faster, scalability pro works well for the importing part. If you are interested in this project, please contact: nathan.brunner@salarship.com
Hi – as mentioned on Discord, if you can set up a staging/dev environment with a job I can run to import and delete the jobs and provide me SSH access then I can take a look into this.
It would be easier if you could provide the slow query logs for the delete operation, for any queries > 0.5 seconds while the delete is running.
If the slow query log doesn’t come up with anything, then I’ll need xdebug installed on your dev server where I can run the delete operation and capture the execution of the delete and step through it to investigate why it’s slow.
Welcome to Super Speedy Plugins, the new home for all the performance-focused plugins made by Dave Hilditch.
We only use functional cookies on our website, no advert-related tracking.Ok
Hi – as mentioned on Discord, if you can set up a staging/dev environment with a job I can run to import and delete the jobs and provide me SSH access then I can take a look into this.
It would be easier if you could provide the slow query logs for the delete operation, for any queries > 0.5 seconds while the delete is running.
If the slow query log doesn’t come up with anything, then I’ll need xdebug installed on your dev server where I can run the delete operation and capture the execution of the delete and step through it to investigate why it’s slow.
You can see how to install Xdebug here: https://www.prelive.superspeedyplugins.com/2022/11/23/installing-xdebug-remotely-debug-wordpress-gather-profile-traces/