cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aristedes Maniatis <...@maniatis.org>
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

Mime
View raw message