It happens sometimes that I may delete 30 appointments at a time (if client cancels). Sometimes when I do this, the server really struggles. I'm wondering if that's kind of expected behaviour and if it's on the user to be mindful and to try and delete batch records in chunks?
Well, it certainly depends on the server's performance. It does take longer time than deleting a couple of appointments, but it shouldn't take too much time. You can do this from the front, but certainly deleting it from the database it's the fastest way. Of course, it is more convenient to delete them from the front end (backend section) than from the database.
Thanks for the screenshot. Well, there is certainly a way to optimize the queries, but the loading speed and those queries depend on the hosting package and server performance, in a great way, as stated.
In case you want to delete the appointments in batch, you can also look for the database table "wp_amelia_appointments" and then delete them from there. This is certainly a faster way than deleting them one by one.
Hi team
It happens sometimes that I may delete 30 appointments at a time (if client cancels). Sometimes when I do this, the server really struggles. I'm wondering if that's kind of expected behaviour and if it's on the user to be mindful and to try and delete batch records in chunks?
Ronnie
Hi Ronnie,
Well, it certainly depends on the server's performance. It does take longer time than deleting a couple of appointments, but it shouldn't take too much time. You can do this from the front, but certainly deleting it from the database it's the fastest way. Of course, it is more convenient to delete them from the front end (backend section) than from the database.
Kind Regards,
Stefan Petrov
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Stefan,
I hear that. It could indeed be just a me thing. I may upgrade server. In the meantime, I did ask my host and they sent me the attached.
Take it with a grain of salt, but the support with my host sent me the attached image
In the meantime, I will just delete 10 records at a time, instead of 30.
Attached files: Screenshot 2024-11-04 at 9.46.35 am.png
Hi ronnie,
Thanks for the screenshot. Well, there is certainly a way to optimize the queries, but the loading speed and those queries depend on the hosting package and server performance, in a great way, as stated.
In case you want to delete the appointments in batch, you can also look for the database table "wp_amelia_appointments" and then delete them from there. This is certainly a faster way than deleting them one by one.
Kind Regards,
Stefan Petrov
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables