andrew_s_vaz wrote:

>
> 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

Andrew,

I do not exactly know what you mean with table.locate.
If this has something to do with Delphi Programming than beware.
Do not use Table at all. This is a SQL-Database and not something like
Paradox or Dbase. ALWAYS use Sql-Queries.
If i didn't understand, please ask again.

Uwe