Performance of upper()

Posted in 1998

Marty Allred — Tue, 18 Aug 1998 15:35:27 +0000 — source: Informix-list mailing list archive (1991-1998)

We're having some real problems with the horrible performance of using the SPL version of upper(). In comparing our options on how to work around this, we're considering just upgrading to 7.3x so we can use the built-in upper() function. What kind of performance improvement is there in using the built-in function as compared to the klunky SPL version? Is it strictly a matter of convenience or is it really faster? -- Marty Allred Informix DBA, Orchestrate.com