Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INDEX TAG on DELETED() ......... HUMBUG
Message
De
16/03/1999 14:11:07
Walter Meester
HoogkarspelPays-Bas
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00198031
Message ID:
00198257
Vues:
23
Jim,

>My tests included a close all and clear all between each select statement. The difference between query times with rushmore is directly related to the number of record sin the result set. My tests got 1,000's of record in the result, what was the size of your result set?

About 16000.

Only this 1.000 records are checked on their deletion status and because VFP has to copy this record one by one to a cursor only the ones which are deleted decreases the performance.

Walter,
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform