Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Extra memo
Message
From
28/02/2008 12:54:12
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01297347
Message ID:
01297470
Views:
11
>>Maybe not if the memo is just a log - it would never have been updated, hence no unused blocks.
>
>I hear what you are saying, but I would at least try it before changing the block size. The default is 64 bytes and the smallest you can set it is 33 bytes. Unless he has over 10M records in that table, you are not going to notice a big difference. And if he changes it to 67 bytes it will get worse instead of better.

The optimal blocksize can be calculated from the lengths, that shouldn't be hard to do, but I agree the exercise may prove to be futile. There's the zero size (i.e. use actual size) option, which may be optimal for a case like this. It minimizes the unused space because it doesn't use blocks. It may have overhead somewhere else, though.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform