Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Perfomance and a tag on Deleted()
Message
 
 
To
17/04/2000 17:36:17
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00360655
Message ID:
00360660
Views:
8
>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

There have been a number of threads here that show that if you do not have a large number of deleted records, then this can actually slow a query down dramatically.

There was one user who tracked the existence of a DELETED() tag to a prblem where a query was taking over 2 minutes with it and 5 seconds without for a large table.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform