Re: Referential integrity

Philippe Fornaciari <p.fornaciari@summittechnologies.com> wrote in article <6jicse$mp1$1@news.xmission.com>... > > Hi all, > > I am using Power designor to build the conceptual and physical model of > my project. To build my database (Informix OLWS 7.22 ) from my physical > model, there are two ways to generate referential integrity in the > database : > > * Using triggers and stored procedures > or > * Generate declarative statements in a SQL script > > > What is the best method for performance ? > Philippe, My preference is to use declarative statements because: a) they're simpler (Powerdesigner will write them for you). (True, Powerdesigner will actually write them either way but there's just less and simpler code this way.) b) The database will know the dependencies. If you need to update table A, looking at the dependencies will tell you that this directly affects tables B & C, and indirectly also table E. This is important information. (You could get it out of a trigger but it's tougher to find this.) b) they're in Informix's area of responsibility. They will keep these tuned and highly efficient. c) they're portable -- everyone now supports this David > Best regards. > > > Philippe Fornaciari > Summit Technologies International > p.fornaciari@summittechnologies.com > > -- David Samson, Senior Database Researcher dsamson@ndsisrael.com NDS Technologies Israel Ltd. +972 2-589-4529 PO Box 23012 Fax: +972 2-589-4578 Jerusalem, Israel Cellular: +972 51 287 481