Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo bloat
Message
From
05/10/2005 02:33:59
 
 
To
05/10/2005 01:56:59
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01056130
Message ID:
01056135
Views:
34
>Hi,
>I have an issue of memo bloat. I'm concerned that if I change the default 64 to 0 it will cause issues with the program. But I have do something soon. Daily the fpt file grows 10 fold - 103000 before and after 10000 bytes - after a pack memo.
>
>So does anyone have a history of making the change?
>
>John

John,

When a new memo is added or an existing is changed the blocks are allocated in 64 byte chuncks, so on average there is a waste of 32 bytes/memo
Changing a memo does not happen 'in place', the whole memo is rewritten, the old apace is not re-used, hence the bloat

setting the block size to 0 will get rid of the 32 bytes waste/memo, so there'll be some gain

What you are experiencing is imo a bloat due to a lot of replaces or delete-insert and setting the block size to zero will not improve much.

As to your concern, all my memo fields have been created with block size 0. I have not had any problems with that

So, it's worth trying. Just don't expect too much of it
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform