I have two tables, having parent-child relation. Each table contains around 14 lakh records. I want to delete data from the parent table along with the associated records in child table. The count of records to be deleted is around 4 lakh. Directly firing a DELETE query in SQL freezes the database server. As the database is being used, I need a solution which will not cause the database to freeze. There are no indexes on both tables, but there are foreign keys in 4 other tables which reference a column of the child table (mentioned above). Is there something which can speed up the delete process without freezing the database?
CASCADE DELETE
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)