Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INDEX TAG on DELETED() ......... HUMBUG
Message
De
23/03/1999 15:32:06
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00198031
Message ID:
00201162
Vues:
14
>Hi Bill,
>
>>Well, this doesn't sound too detailed, more like a general answer given to a general question posed somewhere.
>
>Right, but that's the only official statement I could find in that regard.
>
>>I am wondering how the MS Rushmore gurus would answer the issues posed in these two threads in a detailed manner.
>
>The problem is that Rushmore is protected by Microsoft and those people that know exactly how it works, can't tell you about it.
>
>Christof

Agreed. However, we're not asking them to tell us how it works, just in light of how they know it works, what should we do in a given situation. I know they can't cover all possibilities, but this is a major one that affects all of us in probably most applications. And I remember at DevCon 96 (VFP5), George Goley stressing to do queries, if at all possible, with SET DELETED OFF for speed. But if DELETED was SET ON, you better have that index on DELETED(). At least, that's what I remember and I'm not trying to put words into George's mouth. And if I'm not correct on this I will retract. At any rate, it seems the issue is not quite as clear cut as this and I would appreciate it if the MS crowd would address it since, it would seem, they are the only ones who can really know the bottom line.

Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform