>Fred:
> I just did a test: I copied the .dbf file from the production to the development area and ran the app.. It speed was very slow. I import the records from the production area to the table in the development area the sql statement ran a lot faster. We do reindexing nightly. Do you know what causes that?? thanks.
>sherry

I saw something similar on a FPW2.6 app when reindexing didn't help. Only deleting the cdx file and recreating fixed teh problem. We ended up changing the backup routine to crate a new file each time and append the existing data back into it.

The backup routine would create a new main data file from the current production data structure file ( a file that contained the structure of all the tables) and index it. We set the order of the renamed main data file to a tag index descending (numeric counter) inorder to get the most recent records append in first. Then we began inserting the data back into the file. We would let the users back in after about 200 records were inserted in. The users would be locked out of the system for about 45 seconds and it would run slow for about 30 minutes while the data was moved back in.

Hope this helps.