Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rushmore Design Flaw Heads-UP!
Message
 
 
To
09/07/1999 13:41:47
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00238826
Message ID:
00239912
Views:
20
This statement is not correct, at least when Set Deleted is ON. In the classes I teach, I have a 1.5 million record table to illustrate the effects of having a tag and not having a tag on deleted records. The difference in performance is quite impressive.

Set Deleted On is an implicit filter on deleted records. As with any filter, for best performance, especially when dealing with a large data set, you should have an index on that filter expression.

In terms of being a burden, I don't quite understand that. Indexes always have to be maintained anyway. One additional index is really not that big of a deal.

My 2 cents...



>>By now it well known that the deleted() tag is almost always more of a burden than this does good.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform