Re: TRIGGERS

Posted in 1998

Art S. Kagel — Mon, 17 Aug 1998 18:11:25 -0400 — source: Informix-list mailing list archive (1991-1998)

Erik Nis Jessen wrote: > > We are using the following in our product: > [SNIP] > I am worried about the TRIGGER part. It was written by an ex employee and > I am not sure about the performance hit we can expect when used on large > tables (>50000 rows). The performance hit will be more related to the number of updates than the size of the table because of the added overhead of each update triggering another. However, if you make sure there is a unique index on k_id, yes Virginia it IS possible to have a non-indexed SERIAL type column, there should be no problem. Art S. Kagel