Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculate # of rows to hit 2G
Message
From
25/08/2000 21:20:14
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00406470
Message ID:
00409491
Views:
25
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform