Hi.

I have a product table with 6000 records. I'm using txtquickfill in a form to pick up a product code. It works fine, in my local developer machine. Once I ported this to the client network, it got really slow. I have an index for the product code field and one for the product name.
With the code, is lightning fast, but with the name, turtle slow.
The only difference between them is that the code's length is character 15, and the name 60.
Saw that Dave uses "locate for" to search for a match. I have tried to set the lExactCase to .T. , index on UPPER(code_name). Before I set lExactCase to .T. , the search on the Code was slow as well, as the code wasn't indexed on UPPER.

Any ideas on what else should I look at before I subclass the thing and put SEEKs replacing the LOCATEs ?

Thanks.