UDR Performance Question

Posted in 2004

Topics: Performance & Tuning, Stored Procedures & SPL, Platform-Specific Issues, Java & JDBC Development

Sean Baker — Mon, 1 Mar 2004 08:01:38 -0800 — source: Usenet: comp.databases.informix

This is a multi-part message in MIME format. ------_=_NextPart_001_01C3FFA6.9A9C42E7 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Hello All, We've been using SPL routines with some very good success the past year (IDS version 9.3, soon to be 9.4, running on AIX 4.3, soon to be 5L). We are also going to start using Java UDR's as well, and possibly some UDR's written in C. My question is, regarding straight performance of getting data out of the IDS database and returning the results, which UDR platform has the best performance (SPL, Java, C)? In my mind, I would think SPL would be the fastest since it's basically internal to the Informix database. As far as procedural logic performance (processing of flow control statements), I can't imagine there is much difference between the 3. Is there an obvious choice where performance is concerned? Can someone point me to some documentation on this subject? Thanks, Sean. - - - - Sean Baker, Application Development Money Mailer, LLC 14271 Corporate Drive Garden Grove, CA 92843 714.265.8288 ph 714.265.8362 fax ------_=_NextPart_001_01C3FFA6.9A9C42E7 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 6.5.6944.0"> <TITLE>UDR Performance Question</TITLE> </HEAD> <BODY>  Hello All, We've been using SPL routines with = some very good success the past year (IDS version 9.3, soon to be 9.4, = running on AIX 4.3, soon to be 5L).  We are also going to start = using Java UDR's as well, and possibly some UDR's written in = C. My question is, regarding straight = performance of getting data out of the IDS database and returning the = results, which UDR platform has the best performance (SPL, Java, = C)?  In my mind, I would think SPL would be the fastest since it's = basically internal to the Informix database.  As far as procedural = logic performance (processing of flow control statements), I can't = imagine there is much difference between the 3.  Is there an = obvious choice where performance is concerned?  Can someone point = me to some documentation on this subject? Thanks, Sean. - - - - Sean Baker, Application = Development Money Mailer, LLC 14271 Corporate Drive Garden Grove, CA 92843 714.265.8288 ph 714.265.8362 fax </BODY> </HTML> ------_=_NextPart_001_01C3FFA6.9A9C42E7-- sending to informix-list

↪ replying to Sean Baker

Obnoxio The Clown — Mon, 01 Mar 2004 17:41:30 +0000 — source: Usenet: comp.databases.informix

Sean Baker wrote: > This is a multi-part message in MIME format. > > ------_=_NextPart_001_01C3FFA6.9A9C42E7 > Content-Type: text/plain; > charset="US-ASCII" > Content-Transfer-Encoding: quoted-printable Don't post frickin HTML :o( > We've been using SPL routines with some very good success the past year > (IDS version 9.3, soon to be 9.4, running on AIX 4.3, soon to be 5L). > We are also going to start using Java UDR's as well, and possibly some > UDR's written in C. > > My question is, regarding straight performance of getting data out of > the IDS database and returning the results, which UDR platform has the > best performance (SPL, Java, C)? In my mind, I would think SPL would be > the fastest since it's basically internal to the Informix database. As > far as procedural logic performance (processing of flow control > statements), I can't imagine there is much difference between the 3. Is > there an obvious choice where performance is concerned? Can someone > point me to some documentation on this subject? For database access and simple routines, SPL is probably fastest. For complex or iterative routines, C is faster. Java just sucks lemons. :o) > Thanks, > > > Sean. > > - - - - > > Sean Baker, Application = > Development > > Money Mailer, LLC > > 14271 Corporate Drive > > Garden Grove, CA 92843 > > > 714.265.8288 ph > > 714.265.8362 fax > > > </BODY> > </HTML> > ------_=_NextPart_001_01C3FFA6.9A9C42E7-- > sending to informix-list -- "C'est pas parce qu'on n'a rien ''' dire qu'il faut fermer sa gueule" - Coluche

UDR Performance Question

Glossary

Your privacy choices