Re: Performance of upper()

Posted in 1998

Art S. Kagel — Tue, 18 Aug 1998 18:21:41 -0400 — source: Informix-list mailing list archive (1991-1998)

Marty Allred wrote: > > 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? Orders of magnitude faster. The SPL code is indeed a kludge. Art S. Kagel