Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Perfomance and a tag on Deleted()
Message
 
 
À
17/04/2000 17:36:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00360655
Message ID:
00360660
Vues:
7
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform