04-07-09, 04:22 #1Registered User
- Join Date
- Apr 2009
Unanswered: How to optimize the delete operation on related tables?
I have three related tables and the Foreign Key contraints on them is ON DELETE CASCADE
The DELETE operation takes a long time (which is unacceptable).
Plz advise me on how to optimise this operation for performance.