Hi,

regarding to GDPR rules I have to delete Customers which had no appointment since one year. I figured out that I can do this by hand sorting customers by booking date sorting oldest first, and then marking all customers on a page and press delete.

BUT unfortinatelly this is not working - even when they are marked, only about 5-8 customers will be deleted - and the deletion needs more than one minute to happen.

I searched for an option where I can say "delete all customers where the last appointment was a year ago" as GDPR is requesting to do regullary - but no luck so far. Also believe it is not a good idea to delete them in the database without checking their linkings to may newer appointments....

By now I have to delete 4000 customers getting each day more and more added to the system

But it is impossible to do this due to aboves problems.

Have you any suggestions how I could speed up this process or what settings I should check?

Thanks in advance!

little update: I looked into the network monitor of my browser and there I see following response:

HTTP 500: message    "Unable to save data in AmeliaBooking\\Infrastructure\\Repository\\AbstractRepository SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction"

Sorry no admin access for people outside of the customers organization. 

But it is nothing related to settings. But more related to the payment table (see MySQL trace log) 

Maybe this is related to a missing index in the payment table? 

We are using the latest 7 version and not 8. But it worked with the older version (before 7)better

Hi Uros, I added now some index-rules for the database and now it works with good speed again.

Maybe this should be done by default, so that ID-columns are Indexed for faster run.

anyway you can close this ticket in my eyes.

Believe the problem was missing index in Payment and Cache table (parentId columns)