Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
Piet,
I've been involved in a discussion with several people about the DELETED() tag about a year ago, The outcome was that the DELETED() tag was only helpfull in a few particular circumstances. From the top of my head:
- If you want to get maximum performance out of a COUNT command with SET DELETE ON
- If you've got significant amounts of deleted records in your table ( > 10% )
- Tables are not too large ( < 1.000.000 records )
In all other circumstances there is no significant performance gain for the DELETED() tag or a performance drop just by adding a TAG ON DELETED().
The best thing that helps to optimize your queries is to have a good understanding of how rushmore and other index-aware commands work. This isn't a quite simple topic, it's both theory and a lot of testing.
Walter,
>Some documentation (hackers guide) say dat including a tag on
>deleted() records in a table increase performance in SQL select queries.
>
>However in Foxpro Advisor there was an article that it can also slow down queries.
>
>Has anyone tested this,
>
>Please advise
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