Brian, definitely one of my concerns was dealing with changes that were needed in the future so I like the idea of the subtriggers. In my little bit of testing I found that you don't want to be messing with these very often after you set them.
Jeff, are you suggesting that I can use an index instead of a trigger. It seems like I did something like this before with an I-description calling a subroutine but it seemed like I had some issues in there. Maybe I'll give that another try as well and see which fits better. Thanks for the help. On Wed, Oct 8, 2008 at 4:54 AM, Brian Leach <[EMAIL PROTECTED]> wrote: > One gotcha is that once a trigger is on there, you can't easily > change/extend it unless your system has a downtime period in which everyone > is logged out. For this reason on 24x7 sites I use a master trigger that > can > call subtriggers, held as a list in a parameter file. This means that a new > subtrigger can be inserted, old subtriggers removed etc without having to > log everyone out. Yes, it means an extra read and yes it is an imperfect > solution in an imperfect world.. > > And of course remember you are running under transactional constraints when > using triggers. > > Brian > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Mike Roosa > > Sent: 08 October 2008 04:22 > > To: u2-users@listserver.u2ug.org > > Subject: [U2] Universe Triggers > > > > We are getting ready to implement triggers on a universe > > system running under Windows Server 2003. I created a > > trigger and tested it out and it appears to do exactly what > > we need. My question is are there any gotchas or issues we > > should be concerned about with triggers? Are there any > > performance issues that anyone has seen related to triggers? > > > > Thanks, > > Mike Roosa > > ------- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
