Re: Triggers

jfk@sigsys.com wrote: > > Hello all, > > I was wondering about a trigger performance issue that we are > coming across currently. > > I am in the process of converting our Oracle database to Informix 7.1 > and I am noticing quite a few things that concern me. I hope someone > can help clarify a few things for me. > > Since I'm no longer to declare variables in triggers, I have to > create a stored procedure to do my log table inserts (I need a few > other fields in the log table that I add during the insert). Is this > going to create a major I/O bottleneck for us? We have about 30 users > at a time using the system. Other than user, today, current etc... > > I was also wondering if there was a way to keep a global database > variable. I read about the DEFINE GLOBAL statement, but I am not sure > how the database locks that variable if multiple users are trying to > update/access it. the define global declares a variable for a single session. If you want one for the whole database (last Order number used or something similar) you're best off putting it in a table...