RE: C UDR vs. SPL

Posted in 2000

Watson, Paul — Wed, 29 Nov 2000 10:36:43 -0000 — source: Informix-list mailing list archive (1991-1998)

If you are doing pure sql then then SPL should be quicker, as you bring in more conditional processing then the gap will close until the UDR is quicker. I only drop to UDRs when the functionality is not readily available in SPL. Paul Watson # WF Software Ltd # All answers are +44 1435 674629 # pure fantasy +44 1436 678693 # www.wfsoftware.com/informix # > -----Original Message----- > From: Bogdan Neagu [mailto:bogdan.neagu@alcatel.com] > Sent: Tuesday, November 28, 2000 04:27 > To: informix-list@iiug.org > Subject: C UDR vs. SPL > > > Hi all. > > Let's close the eyes for a second and imagine a stored procedure that > does 'stuff', and a C UDR that does the same 'stuff' (in IDS > 9.21 FC2-1 > on Solaris). The 'stuff' can be something like 'select field1, field2 > from table where key = value;'. > > Which one is supposed to be faster ? > > Thanks, > > Bogdan Neagu >