Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
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