Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo bloat
Message
From
05/10/2005 15:06:47
 
 
To
05/10/2005 07:31:19
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:
01056421
Views:
26
>SNIP
>>>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
>>
>>This is not true, if LEN(memo) it doesn't overcome CEILING(LEN(memo)/BLOCKSIZE)*BLOCKSIZE
>>blocksize it rewritten the memo in place.
>>
>SNIP
>
>Fabio,
>
>Please check out Re: .FPT files - bloat and re-writing of file header Thread #971406 Message #972068
>
>It says, as I read it, that memo field is always re-written.
>
>cheers

Hi Jim, thanks.

My affirmation is inaccurate because I use all the tables in exclusive way;
I don't consider VFP databases sufficient for to share data among more consumers.

Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform