I've never seen before insert trigger being slower than doing the same thing in the client code. I guess it would depend on what you are doing in the trigger and how many sequences are cached (but the amount cached would also have the same effect with client code).
----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Monday, September 06, 2004 9:06 PM To: Reidy, Ron Cc: Jean-Pierre Utter Löfgren; DBI List Subject: RE: How to use sequences in DBI/DBD::Oracle with bind On Tue, 2004-08-31 at 07:36, Reidy, Ron wrote: > Use a before insert trigger to populate the column. > Triggers have the cachet of being a neat way to automatically populate key columns, and I have used them many times myself. They are also much slower than the posters original code. Jared This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
