Re: When and when not to create SP/triggers

Posted in 1997

David Williams — Fri, 19 Dec 1997 03:03:49 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <19971218230300.SAA29693@ladder01.news.aol.com>, KPonn <kponn@aol.com> writes >Hi, > >I am having trouble deciding when to (or when not to) create stored procedures >and/or triggres. I know they are useful and there is overhead involved. We have >PB application and all PB developers bug the hell out of me to create triggers >and SPs. How do I decide if an SP or trigger should be created or not created. >When I ask PB people why do you need it, I get "to reduce network traffic" >response. How can I get a better grip on this issue (books are not helping me >much!) ? > >Thanks. >Keith Read the FAQ at http://www.smooth1.demon.co.uk Look at Section 4.8 Stored Procedure Language (SPL) -- David Williams