Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calculate # of rows to hit 2G
Message
De
25/08/2000 21:20:14
 
 
À
25/08/2000 19:35:32
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:
00409491
Vues:
26
>>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.

Yep, I get nRowWidth from the Table Designer | Table tab, so it already includes the delete status.
I should have mentioned that.

Good catch. Basic algebra - 2^31 ... duh

Thanks.
Insanity: Doing the same thing over and over and expecting different results.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform