Re: Triggers/sequences or interface code

"J. Harris" <John.Harris_at_nurs.utah.edu> wrote in message news:aac4nr$prm$1_at_coward.ks.cc.utah.edu...
> For incrementing PK or unique ids what is the "recommended" method for
> achieving the best result: using triggers on insert events or manually
doing
> it at the interface level (i.e., using vba with access, or using
coldfusion,
> etc).
>
> John Harris
> University of Utah
>
>

At the lowest level that is applicable, in this case triggers. Using VBA with Access or Coldfusion means running this code at the client side, and triggers run at the server side. Hence your second proposol will be much much slower.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address