[noise][Netiquette] Re: Design approaches about primary key

"Sybrand Bakker" <gooiditweg_at_sybrandb.nospam.demon.nl> a écrit dans le message news: dtqhsvcqlrpnogdfso8hn90m2spvbpe3pa_at_4ax.com...
> On Fri, 28 Nov 2003 22:52:00 +0100, "Sven Kolar"
> <devnull_at_svenkolar.net> wrote:
>
> >OLTP:
> >Surrogate keys should IMHO be avoided in OLTP
> >implementations. Main reason: avoiding excessive lookups
> >during atomic-transaction SELECTs, UPDATEs and
> >INSERTs (which are plentiful in a typical OLTP setup). This
> >approach simplifies my access logic (client-side DML), plus
> >lessens the load on the server (no lookup joins!) -- join-hashing
> >notwithstanding.
> >
>
> Utter crap. Lookup tables should be in the keep buffer pool.
> And lookup tables are usually small.
>
>
>
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Hi Sybrand,

I'm not the mod of this NG but I'm sure "utter crap" is not the correct word to answer
somebody who may have made a mistake (i.e. Sven)

As I've already told you in one of my replies to you, if you want to answer somebody you don't agree with, simply write a nice post explaining your opinion, even being ironical but staying polite please.

I think your practise of English language allows you to do that, Sybrand ?

Cheers,
Alkos

PS
I was figuring myself that northern european people was gentle, polite and cool-blooded maybe it's another myth . . . Received on Mon Dec 01 2003 - 02:56:35 CST