Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calculate # of rows to hit 2G
Message
De
25/08/2000 19:35:32
 
 
À
17/08/2000 20:34:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00406470
Message ID:
00409483
Vues:
21
>For some documentation, I need to calculate the number of records that a given table would need to have in order to hit the 2G file size limit.
>
>My formula so far is
>
>nSizeOfEmptyTable + 2*(2^30)/nRowWidth
>
>Is there anything I'm missing, doing wrong, etc?
>
>TIA

Shouldn't that be:

((2**31) - nSizeOfEmptyTable) / nRowWidth


Don't forget that a row consists of one extra character for the DELETED status.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform