Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dotnetpro database performance contest
Message
From
14/05/2007 13:33:42
 
 
To
14/05/2007 09:13:40
Markus Winhard
Lauton Software GmbH
Nürnberg, Germany
General information
Forum:
Visual FoxPro
Category:
VFP Compiler for .NET
Miscellaneous
Thread ID:
01224231
Message ID:
01225303
Views:
36
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
Previous
Reply
Map
View

Click here to load this message in the networking platform