I like taking full advantage of the database server and it's enforcement
to keep out bad data, but I also can appreciate the perspective of
having the RI logic in the data tier and just treating the backend as
"big dumb storage" so as to make your app much more portable and not
tied to any particular backend database.
Like so many situations, I guess it all "depends" on your need.
--Mike
On 2015-05-26 12:13, Richard Kaye wrote:
For those of you who are not familiar with this site, there's a ton of
excellent SQL Server info here. They also post about Oracle on
occasion but as I have no experience with Oracle I don't know how
useful those might be.
<http://www.brentozar.com/archive/2015/05/do-foreign-keys-matter-for-insert-speed/>
--
rk
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
