Re: Triggers and performance

In article <4ok4be$42g@news.roadway.com>, hc33@summitis.com (Mark Palumbo) says: > >Could someone who has used Informix triggers please comment on how >they affect performance. > >Is it better to let our ESQL/C programs do the kinds of things triggers >will do for us? (opinions welcome) > >Thank you, Mark All depends The trigger is an object on the database and as such it executes just that bit quicker. However if you are dealing with external files then it can't really help and ESQL/C is as good a tool as any Perhaps if you explain what you want to do with the triggers you might get a better answer Rgds Terry