Problem with deleting guest customers in 2.0

Our DeleteGuestCustomers function is not deleting the guest customers from the customers table because of the Log_Customer foreign Key constraint on the Customer_Id field of the Log table. When I remove this constraint it deletes them as it should. Is there any reason this should be the case? Can we safely remove that constraint?

We noticed this when our customer table had filled up to about 16k records, and only about 20 of them were registered users. This caused extremely slow load times as the site was trying to add a guest customer and role.

Sure, remove this constraint. This issue is fixed in upcoming 2.30 release. Please see changeset f0d4c4b45c82

Thanks for the reply! We set the constraint to cascade delete the log records if we delete the Customer. Its working fine now. Thank you