Re: Triggers and performance

Posted in 1996

Cheryl Kendricks — 30 May 1996 12:38:08 -0400 — source: Informix-list mailing list archive (1991-1998)

Depends on Engine (ONLINE/SE version 5 or less or version 6 or 7). It also is important that your DB with triggers is not in your ROOT. Supply more. Presenlty WE are using triggers and stored procedures with no performance problems on 7.12 Online, DB out of ROOT in seperate DBSPACE and alot of TEMP dbspace. Yet I've have not had 20 concurrent USER's on it either! ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Fax: 512-393-7296 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On 30 May 1996, Mark Palumbo wrote: > 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- > > ------------------------------------------------------------------------ > Mark D. Palumbo, markp@summitis.com Roadway Express, Inc. > 330-384-9000 Ext 3332 1077 Gorge Blvd., Akron, OH 44310 >