Stored Procedure/Trigger Performance question
Date: Mon, 14 May 2001 14:15:14 GMT
Message-ID: <SLRL6.982$U61.16728_at_news2.mts.net>
Here is my scenario:
We are a small shop using Oracle 8i for development. We don't have anyone
with professional DBA training and so our most senior programmer has taken
this role. She is currently trying to setup triggers so that we can send an
Now I've done some DBA work on MS-SQL Server before (not certified however)
My question is, which is faster? A single stored procedure to update the data, or a series of triggers? I have also been told that there are limitations to what triggers can access. Is this true as well?
Thank you,
Scott Pawluk
Programmer/Analyst
City of Winnipeg
PS-To reply directly, remove the nospam from my email address. Received on Mon May 14 2001 - 16:15:14 CEST