Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dotnetpro database performance contest
Message
De
14/05/2007 13:33:42
 
 
À
14/05/2007 09:13:40
Markus Winhard
Lauton Software GmbH
Nürnberg, Allemagne
Information générale
Forum:
Visual FoxPro
Catégorie:
VFP Compiler for .NET
Divers
Thread ID:
01224231
Message ID:
01225303
Vues:
38
Hi Markus,
>
>I checked the records in the resulting Table2.dbf. They are absolutely identical to the records our former UNIQUE index found. So, at least with these data, the MD5 hash does what I expect it to do.
>

MD5 is not the fastest one and returns 16Byte - I was planning to check out 4Byte faster returns, as they also should be faster in creating the index.
>
>BTW, I'm aware that this is not sufficient in general. But in this special case...

It might stack the odds more for winning. And if we do the first "replace" by header manipulation, using the hash directly in the index is quite might help even more.

regards

thomas
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform