Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is it reasonable to have index on DELETED()?
Message
De
22/03/1999 17:25:39
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00196021
Message ID:
00200706
Vues:
9
Christof,

I read this several years ago as a "theory". I recollect that the author had good arguments to support the theory, but also had acknowledged that one couldn't at all be sure because this is a proprietary thing which has remained well guarded.

Has there been something since which confirms this, so that it is now reality as opposed to theory?

regards,

Jim N



snip
>
>The Rushmore engine creates a bitmap for any index expression. That's a memory block where each bit represents a record. When a bit is 1, the record is part of the selection, when it's 0, the record is not part of the selection. This bitmap is created based on the index tree. In order to perform logical operations like AND or OR, all VFP has to do is to use bit oriented CPU commands to combine two bitmaps into one. Since that's done on the CPU level, it's quite fast.
>
>Such a bitmap can be re-used until the cache times out, by default about 300 ms. After that, VFP recreates the bitmap if necessary.
>
snip
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform