Dear All,
I have four tables linked together with FK. An example is, deleting an id in one table, deletes 1,000,000 rows in all the others. However, this operation takes 2-3mins (currently this more or less empties the database.) Is this slow?
I have checked that the FK have been indexed and that they have been declared intergers. A full vacuum has also been performed.
Does anyone have any suggestions on how to speed this up?
Thanks
Colin