Re: Integrity on large sites

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