AnsweredAssumed Answered

Certain Find Criteria Slows down find

Question asked by dbreitbach213 on Apr 19, 2011
Latest reply on Apr 19, 2011 by LaRetta_1


Certain Find Criteria Slows down find


We have an "item" field that may contain part numbers (ex: CTC2410-R or CES-3R-3716). The "item" field is indexed and there are about 250,000 records in this database.

If we search on the "item" field using only characters, the results return almost instantaneously! Ex: CTC2410

However, if we search using a dash (or hyphen), it slows down the find tremendously, sometimes almost 30 seconds to return the results. Ex: CTC2410-R

Am I missing something or is there something I do not know about that would be causing this search to bog down?

Thanks in advance.