| From: | "Richard P(dot) Welty" <rwelty(at)averillpark(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Integrity on large sites |
| Date: | 2007-05-23 18:34:19 |
| Message-ID: | 4654892B.7020000@averillpark.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-05-23 18:43:40 | Re: Tsearch2: upgrading from postgres 8.1.x to 8.2.x |
| Previous Message | André Volpato | 2007-05-23 18:28:28 | Remove query results from cache |