Thanks Alan I will try using a blocksize of 0.
Paul -----Original Message----- From: ProfoxTech <[email protected]> On Behalf Of Alan Bourke Sent: 26 May 2020 14:59 To: [email protected] Subject: Re: Memo bloat Sent by an external sender ------------------------------ > The way VFP uses Memo files will always append data to the end. Memo > bloat will happen. If the changed data in bytes > blocksize then it will add a new block. If you keep the changes < blocksize then it will re-use the same space. The trouble is with a blocksize of 64, it's very likely that it will almost always be adding blocks. One way to mitigate is to set blocksize to 0, in which case it will always only allocate as much as is needed. Another way to mitigate is only write to memo fields if they've changed. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/sn1pr02mb3743edad6ce748cefc407ae0a1...@sn1pr02mb3743.namprd02.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
