Now this was a DUMMY ROW used as a placeholder for future brands! It contained only one field that had more than a non-breaking space as a value. And yet the DB still took 141 seconds to check the constraints.
Granted, this is our developement instance where we do all the initial development, building, and testing of the DB scripts before we approve them for moving into unit and integration testing. (The DB instance, app engine, and webserver engine all run on the same Windows 2000 box – that’s why it’s slow.). STILL! 141 seconds to delete ONE ROW! This is why my job sucks 😛