Appropriate Procedures

--------------2FCC53BE4F1C7AADE0CF83E7 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I'm currently examining the database structures of two separate but very similar systems I've been working on for several years now. We're considering combining the two. The databases are and will be accessed both by programs written in Informix 4GL, for Unix systems, and Passport for Windows systems. I've been using procedures primarily for select statements while update and insert statements have generally been handled by the individual programs. I'm wondering if I would see any significant improvement by proceduralizing the update and insert statements. For the most part, updates and inserts are executed from single specific parts of the code (ie: multiple programs rarely execute updates or inserts on any particular table). -- --------------------------------------------------------------------- Scott Holmes http://www.pacificnet.net/~sholmes sholmes@pacificnet.net Independent Programmer/Analyst Passport 4GL HTML Composer Informix 4GL, SQL --------------------------------------------------------------------- There are more things in heaven and earth, Horatio, than are dreamt of in your philosophy --------------------------------------------------------------------- --------------2FCC53BE4F1C7AADE0CF83E7 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> I'm currently examining the database structures of two separate but very similar systems I've been working on for several years now.&nbsp; We're considering combining the two.&nbsp; The databases are and will be accessed both by programs written in Informix 4GL, for Unix systems, and Passport for Windows systems.&nbsp; I've been using procedures primarily for select statements while update and insert statements have generally been handled by the individual programs.&nbsp; I'm wondering if I would see any significant improvement by proceduralizing the update and insert statements.&nbsp; For the most part, updates and inserts are&nbsp; executed from single specific parts of the code (ie: multiple programs rarely execute updates or inserts on any particular table). <pre>--&nbsp; --------------------------------------------------------------------- Scott Holmes&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A HREF="http://www.pacificnet.net/~sholmes">http://www.pacificnet.net/~sholmes</A>; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sholmes@pacificnet.net &nbsp; Independent Programmer/Analyst&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Passport 4GL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; HTML Composer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Informix 4GL, SQL --------------------------------------------------------------------- &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; There are more things in heaven and earth, Horatio, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; than are dreamt of in your philosophy&nbsp; ---------------------------------------------------------------------</pre> &nbsp;</html> --------------2FCC53BE4F1C7AADE0CF83E7--