Delete taking a long time to complete

[Greg Hines]

Hi All,

I have a simple SP that deletes from several InnoDB tables. eg:

BEGIN
   DELETE FROM Table1 WHERE StrID=iSid AND DOB >= StartDate;
   DELETE FROM Table2 WHERE StrID=iSid AND DOB >= StartDate;
   DELETE FROM Table3 ine WHERE StrID=iSid AND DOB >= StartDate;
   DELETE FROM Table4 WHERE StrID=iSid AND DOB >= StartDate;
   DELETE FROM Table5 WHERE StrID=iSid AND DOB >= StartDate;
   DELETE FROM Table6 WHERE StrID=iSid AND DOB >= StartDate;
   DELETE FROM Table7 WHERE StrID=iSid AND DOB >= StartDate;
   DELETE FROM Table8 WHERE StrID=iSid AND DOB >= StartDate;
   DELETE FROM Table9 WHERE StrID=iSid AND DOB >= StartDate;
END

iSid and StartDate are IN parameters for the SP. DOB and StrID have normal indexes on them.

Tables have from a couple hundred thousand records to a couple million records in them and the SP takes about 10mins to complete.

Is there a quicker more efficient way?

TIA

Greg