Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is SCAN to be avoided?
Message
From
10/11/1999 10:43:17
Walter Meester
HoogkarspelNetherlands
 
 
To
10/11/1999 09:54:06
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00289152
Message ID:
00289597
Views:
29
Srdjan,

>good thing to do is to have dummy index
>tag on 'deleted()' which if active, dramatically improves performance on menu
>operations like scan/endscan ,append from,replace all etc.

No this is not. It's an common mistake that the index on deleted() improves performance dramaticly. If there are not many delete records you can only degrade performce with these commands.

Especially when we talk about the append command, VFP has to update the index each time when a record is added, dramaticly slowing performance.

Only benefit of the DELETED() tag can be in tables where huge amounts of deleted records exists and it's not possible to get rid of them in a ellegant way.

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform