Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Estimating increase of DBF table?
Message
From
06/08/2013 09:02:00
Thomas Ganss (Online)
Main Trend
Frankfurt, Germany
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01579882
Message ID:
01579931
Views:
43
>I am attempting to estimate how the size of the DBF will change if I add some fields. Suppose I want to add 3 fields to a table that has approximately 400,000 records:
>Field1 N 3,0
>Field2 L 1
>Field3 N 12,2
>
>Would it be correct to estimate that he DBF file will increase by 400000 x 16=6,400,000 (6.4MB)? (16 being the sum of new fields).
>And also, would be correct to assume that the size of FPT file will not change at all?

For the second, not always. It will recreate the fpt in the size to be expected after PACK MEMO, so it might be smaller. But it will leave the remnants of dbf and fpt on disc - if you are strapped for free disc space think of that.

HTH

thomas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform