Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does index tag on DELETED() help?
Message
From
08/11/2004 02:56:21
Walter Meester
HoogkarspelNetherlands
 
 
To
07/11/2004 11:31:43
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00958911
Message ID:
00959067
Views:
13
Hi Jon,

If you don't have a lot of deleted records in your table, there are only a few very specific circumstances that justify the use of DELETED() indexes.

1. Allow the use of filtered resultsets of SQL-SELECT. Since this seldom a wanted thing, this is not a real good argument.

2. Using the COUNT command on large tables.

3. Finding a deleted record, though you better might use a INDEX ON .T. FOR DELETED() TAG del for that.

For all other cases the use of DELETED() is complete bogus and never helps in performance issues.
Esspecially in cases where the production app is running on a network, it could seriously degrade your performance.

A few years ago, I did protest to a few MVPs/MCPs because of the use of it. I took a lot of examples and persistence to let them see the DELETED() tag was more or a burden than a help. Yes, I'm an authority on this forum regarding this subject and do have a lot of experience in optimizing queries. The missleading thing is as hilmar said is that 'full optimization' does not stand for optimal optimization.

I started my rant in Thread ID: 198031 and Thread ID: 196021, more than five years ago. Shortly after this discussion an article about the issue has been written in FoxPro Advisor.
You'll see that it took me quite a bit of effort to convince well known VFP people about the myth of the DELETED() tag.

Conclusion: If you don't really need it, don't use them.

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform