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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
