Reported By: Uli Becker Reported On: 8/21/2002 For: Version 3.14 Build 1
# 1186Using the Locate Method with loCaseInsensitive Option on Integer Fields is Slow I have a table with a primary index xyID, fieldtype = integer, CaseInsensitive=yes (by default). When using locate('xyID',456,) it is much slower than locate('xyID',456,[loCaseInsensitive]).
Comments and WorkaroundsThe workaround is to remove the case-insensitive flag for the index.
ResolutionFixed Problem on 8/28/2002 in version 3.15 build 1