Subject Cascades on very large databases
Author sqlsvr
How is firebird cascade performance on a very large database (say 100gb) with lots of relations (especially when using natural keys)? I'm assuming it would take hours/days and probably block all other queries. If firebird used internal pointers for the foreign keys, it would be instant instead of hours/days.

How would you delete/update a record that would cause lots of cascades?