RE: Slow trigger in cluster-environment

I would like a little more information. What are the timings for doing the update to the remote box(no trigger) vs a local box. When you say running on the same machine, do you mean different database same instance, or did you have two instances of informix running on the same box? Hope I will be able to help, Will >===== Original Message From "Pentti Tiet'v'inen" <pat@sci.fi> ===== >I'm trying to keep a column up to date in NT-box from HP-UX using a trigger > >create trigger updalo>update of al_vara on alotmnt >referencing new as post >for each row(update eestin@web_consy:alotmnt >set al_vara = post.al_vara >where al_serial=post.al_serial >) > >This is working reasonably well when the Unix side is running in one >machine. Tests shows about 100 updates per second. >When the Unix side is a cluster having two HP-9000 connected together same >trigger works about 20 times slower !!! >I've two cluster-configurations having same problem. > >Any ideas how to start tracking down the problem? >Thanks >Pentti ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------

The only difference should be the network latency to transfer the update record to the server and the confirmation back to the client versus a local shared memory or loopback connection. Art S. Kagel William Rice wrote: > > I would like a little more information. > > What are the timings for doing the update to the remote box(no trigger) vs > a local box. > > When you say running on the same machine, do you mean different > database same instance, or did you have two instances of informix > running on the same box? > > Hope I will be able to help, > Will > > >===== Original Message From "Pentti Tietäväinen" <pat@sci.fi> ===== > >I'm trying to keep a column up to date in NT-box from HP-UX using a trigger > > > >create trigger updalo> >update of al_vara on alotmnt > >referencing new as post > >for each row(update eestin@web_consy:alotmnt > >set al_vara = post.al_vara > >where al_serial=post.al_serial > >) > > > >This is working reasonably well when the Unix side is running in one > >machine. Tests shows about 100 updates per second. > >When the Unix side is a cluster having two HP-9000 connected together same > >trigger works about 20 times slower !!! > >I've two cluster-configurations having same problem. > > > >Any ideas how to start tracking down the problem? > >Thanks > >Pentti > > ------------------------------------------------------------ > This e-mail has been sent to you courtesy of OperaMail, as a free service from > Opera Software, makers of the award-winning Web Browser, Opera. Visit us at > http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail > account is waiting at: http://www.operamail.com/ > ------------------------------------------------------------