Hi all,

I did some searches on the NG and I couldn't find any topic for
this... so, sorry if this seems silly, but working with development
machines everything seems nice (but very unreal) and I don't want to
blow it with my customers (that will crucify me if I upgrade their app
to something slugish) :-).

I have migrated tables from another app to FB and I have made a extra
column for names (no accent chars, all uppercase) and I've indexed it.
Now, how can I use these indexes to do fast searches?

Do I use

table.locate(...)
or
select a,b,c from names like 'MICHAEL%'

These tables tend to have something around 50K-250K rows of names on
them and are "searched" very much by a lot of people. Names are seen
on a grid on a form so they can navigate through some of them.

Does table.locate(...) does a search and drags all the records by wire
to the workstation untill the position of this 'MICHAEL%' guy?
Or does a select make it work faster?

Is there another (aka better) way to do these kind of searches?

Using FB 1.5.1.

TIA
Andrew