Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Randomly select n unique codes from 5mln table
Message
De
09/11/2001 13:41:23
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00579211
Message ID:
00579790
Vues:
31
>
>>So, if the codes are a relatively small number (and I'd put ZIPs in that category), I think either approach would work well. If that assumption is incorrect, then I'd agree, that populating a new cursor in the loop would be the way to go.
>>
>> Jay
>
>Yes, it was for ZipCodes. Anyway, I suspended my tests for now, so I hadn't chance to try either of suggested ideas...

When you're able to get back to it, I'll be interested in seeing what you come up with in terms of performance. If you don't mind sharing <g>.

Jay
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform