Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Minimizing Table Sizes
Message
From
27/08/2007 09:09:19
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Vista
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01250525
Message ID:
01250621
Views:
13
>>Little. Numeric fields that have no decimals, can be changed to int, saving significant space.
>
>Mike,
>
>The Numeric (N) fields are stored in a table as string, including dot and minus sign, if present, each occupying one byte

Thanks, I know. A change from 12 to 9 will make relatively little difference, no? But an int can be a more significant change going from 10 characters to 4 bytes.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform