Just some thoughts. Let us start with "search".
1. "Reindex", it should be done from scratch. Remove index file and recreate it.
2. How do you perform "search"? Is it seek(), seek ..., or indexseek()? Does it depend on the method of searching?


>SOS Folkes!
>
>I have a multiuser system that is becoming too slow on searches and saving. The database is setup with code implied relationships. However, this is not the problem because, for example, there is a simple screen that looks only at one table that has around 52,000 records. It takes about two minutes to search and another three to save!!! I have tried packing, reindexing... to no avail. ANY IDEAS?