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