Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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,
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only