Scott Marlowe wrote:
> 2: Handling RI in the application doesn't scale. If everything you do
> requires you to check in the app, lock the whole table to prevent race
> conditions, and then commit, you'll never scale to any real number of
> users. You can have reliability and performance if you do RI in the
> database. You only get to pick one if you're gonna do RI in the
> application.
the other risk for RI in the app is the possibility of incompatible
implementation
across different app versions or different apps that access the same data.
not at all a fun place to be, that.
richard