informix triggers
--0-504178186-1097831664=:14041 Content-Type: text/plain; charset=us-ascii Hai all, I have basic , In our application ( I am new to this application ) we are using trigers to delete from parent and child tables. We would have achieve this by on delete cascade. Is there any performance issue using on delete cascade. Thanks deena __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --0-504178186-1097831664=:14041 Content-Type: text/html; charset=us-ascii <DIV>Hai all,</DIV> <DIV> </DIV> <DIV>I have basic , In our application ( I am new to this application ) we are using trigers to delete from parent and child tables. We would have achieve this by on delete cascade.</DIV> <DIV>Is there any performance issue using on delete cascade.</DIV> <DIV> </DIV> <DIV>Thanks</DIV> <DIV>deena</DIV><p>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com --0-504178186-1097831664=:14041-- sending to informix-list
On Fri, 15 Oct 2004 05:14:24 -0400, Deenadhayalan Subramani wrote: PLEASE don't post MIME here! Cascade deletes are more efficient and faster than implementing the same functionality using TRIGGERS. No gotchas beyond the danger of overusing them. Art S. Kagel > Hai all, > > I have basic , In our application ( I am new to this application ) we are > using trigers to delete from parent and child tables. We would have achieve > this by on delete cascade. Is there any performance issue using on delete > cascade. > > Thanks > deena