We have been using this plugin for about 2 years now and it has been very successful. The success itself has now kind of turned into an issue (performance). We have over 12,500 completed appointments. We only have 100 - 150 active appointments at any time and it is now taking 2 - 3seconds for the appointment timeslots to load. Remove appointment takes a full 10 seconds to be removed. I have downloaded the old appointments into an excel file and would like to delete the appointments.
1. Is it possible to add a delete button on the Completed tab. It is currently available only on the Removed tab
2. Could you please provide a clean up sql that I could execute on the server to remove both the appointments along with custom field data so I can get better user experience.
In addition, can you please let me know how I can change the Remove checkbox into a button? It is quite an eye sore compared to the rest of the application. Not sure why the developer chose a checkbox when it auto-submits. I would understand if I was able to select multiple appointments and submit for cancellation but if each cancellation is submitted individually, wouldn't a button make better sense?
Thanks in advance