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

Click here to load this message in the networking platform