>>The options which I found most useful was to disable RI temporarily. This is sometimes useful when you need to update data.
>
>Yes, this is a clear plus.
I use this feature mainly in the following case. To update the database for the end-users, I have a program that does an APPEND FROM for each table (the new structure is in a database that has zero records for each table).
In this case, if I disable RI temporarily, the APPEND FROM is about 10 times faster.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)