Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Proper index for date field
Message
De
23/01/2006 03:04:57
Walter Meester
HoogkarspelPays-Bas
 
 
À
22/01/2006 12:01:20
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01089204
Message ID:
01089284
Vues:
47
Mike,

>Actually, a date or datetime is only 8 bytes. TTOC(,1) is 14 so for network traffic, date/datetime would be better. Your initial posting was correct. The TTOC would be necessary for human-readable ordering, not for optimization.

I would be surprised if it makes a significant difference. CDX Indexes create compacted index keys for character index expressions, so a given index node could only be a few bytes long though the whole index expression is 14 bytes long. It would not even surprise me if the tags are exactly the same size.

Walter,
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform