solved Delete Pend Requests

Dazed
Dazed
@dazed
5 years ago
1,022 posts
Has anyone else noticed that deleting a pending request from the dashboard, either a single or multiple select, is taking a long time to complete? This process used to take a split second. I have seen this go for 20-40 seconds before completing. It seems to work but it appears maybe some performance tuning on the query would be good.
updated by @dazed: 03/10/20 06:34:19PM
brian
@brian
5 years ago
10,136 posts
Something is tying your DB up - it's not the delete requests - they are already heavily optimized (all the DS queries have been heavily optimized). 20-40 seconds means your server is either REALLY overloaded or something else has "locked" the database. If you have SQL backups running in a control panel you might want to check there as they will often lock tables while the backup is running.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Dazed
Dazed
@dazed
5 years ago
1,022 posts
Happy Thanksgiving Brian. Yeah something is definitely up. May be time for an upgrade.
brian
@brian
5 years ago
10,136 posts
Dazed:
Happy Thanksgiving Brian. Yeah something is definitely up. May be time for an upgrade.

Yep let me know if you're thinking about an upgrade - I know you're running on a fairly old server now. We might be able to set something up for comparable cost on JR hosting - ping me with a support ticket if interested :)


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Dazed
Dazed
@dazed
5 years ago
1,022 posts
Hey Brian. I opened a ticket.