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.