cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aristedes Maniatis <>
Subject Re: case insensitive =?
Date Fri, 16 Sep 2011 00:22:35 GMT
On 15/09/11 10:10 PM, Arturo Perez wrote:
> Alternatively, are there any dangers to using likeIgnoreCase if I can be
> 100% certain that $parm will never contain any SQL wildcards?  Seems
> that query runtime is a little slower that =.

I can't imagine that there would be any measurable difference in the database speed of a LIKE
query (with no wildcards) and an = query. You may be over-optimising this bit of code. Perhaps
you could run some tests and report back here on the difference.

Aristedes Maniatis
GPG fingerprint CBFB 84B4 738D 4E87 5E5C  5EFA EF6A 7D2E 3E49 102A

View raw message