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: [email protected]
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.
December 6, 2022 @ 2:28 pm
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.wpintense.com/2022/11/23/installing-xdebug-remotely-debug-wordpress-gather-profile-traces/