Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INDEX TAG on DELETED() ......... HUMBUG
Message
From
16/03/1999 14:11:07
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00198031
Message ID:
00198257
Views:
20
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
Map
View

Click here to load this message in the networking platform