On 9 September 2010 13:39, silky <[email protected]> wrote: > I agree on "heavy" use, but I certainly think there is an area of > "legitimate" use, no?
No. :) > I often have one or n triggers in any given > database (~5 in total?) for little items. And changing it over to a > stored-procedure based system just wouldn't be appropriate (IMHO, > because it's all handled via the OR/M). > I *am* on the opposite end of the opinion scale to the rest of the Internet when it comes to OR/Ms. :) I'm pretty sure you'd be happy with general use of them, right? Or > flat-out no use at all? > Flat out no use at all unless you had some pretty damned clear guidance on what constitutes acceptable use or not. Users of the database write SQL and the SQL does not do what it says on the tin as a result of triggers changing the nature of the set operations. That automatically qualifies them as having a negative impact on your application in my book. -- *David Connors* | [email protected] | www.codify.com Software Engineer Codify Pty Ltd Phone: +61 (7) 3210 6268 | Facsimile: +61 (7) 3210 6269 | Mobile: +61 417 189 363 V-Card: https://www.codify.com/cards/davidconnors Address Info: https://www.codify.com/contact
