>Hi,
>
>I am using the VFP 7.0 with table has over than 50000 records; each record has an Id and a description. I am trying to do a text search on the description field with issue a select statement. the search talk a logn time to search (about 12 sec.) searching for a record. the table on a network the network speed 1gb connection there is 5 user's using the table
>
>. is there a way to speed up the search.
>. is there any text search tools to help.
>
>
>Best regards

1. Can you show your select statement?
2. Do you have an index on Description field?

If you want to search for a word inclusion, native VFP search would be slow with LIKE %word% operators.

Check Re: Wanted: last version of phdbase Thread #1054612 Message #1054653