Hi Sherry,
Sounds like you are suffering from the dreaded cdx bloat which happens every time you issue a REINDEX.
Best to DELETE TAG ALL and re-create the index from scatch.
Regards
Doug Johnston
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement