Hello,
I'm trying to improve the speed of a search form used to display all entries in my database which contain a given value. I'd like to know if there's any way of improving the time it takes to return the results (currently about 5 seconds).
The details:
- search is done in one field in one table with about 13,000 entires. The field is text, length 8, and the search value is entered in an unbound field and used with a command button to set the filter string to: Like "*" & STRING & "*" (or whatever the correct syntax is)
Example of the field to search in the table:
12345-00
42648-01
42648-02
56843-00
54868-02
etc...
Example of string to search for: "42648". This should return 42648-01 and 42648-02
- the search field is indexed. This doesn't appear to make a difference
- interestingly, when I search the "title" field, which is also a text field length 255, as opposed to mainly numeric, it is almost instantaneous
Any ideas?
Thanks in advance