Because we're not able to make Drupal behave in quite the way we wanted, Eric has created an "Ask Spokey" forum which will allow people to review questions and their answers more easily in future. The scrolling list of blog entries makes it difficult to find anything after a while.

The forum is here.

Davorin wrote:

OK Spokey,

you asked for it! :)

We have 3 tables of significant size, whatever that might mean, let's just assume it takes some time to build FK's and underlying indexes.

tab1: col11 (PK)
tab2: col21, col22
tab3: col31, col32, col33

Initially we only have primary key on tab1.col11.
At one point in time we want to add two foreign keys, one on tab2.col21 and another on tab3.col31, both referencing tab1.col11. Let's also assume no apps are connected to the instance/database we work with.
Now, to save time we want to build FK's in parallel so we kick of two separate scripts, one to build a FK on tab2 and another one to build it on tab3.