At 08:56 2016-11-03, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
On 2016-10-28 10:24, Kevin J Cully wrote: X DBFs - I have a client that insisted I use DBFs for his desktop and Web-Connection site. It's run almost flawlessly since 2008 with the exception of the 'memo field bloat' issue. That's caught me a couple of times over the years hitting the 2G limit per file.
I'm handling one of Jeff Johnson's (RIP) clients and having this issue. I was about to create a simple utility for the end-user to grab the table and pack it, but curious if you've got a better idea?
I have a routine that packs and reindexes all of the tables. I have not needed anything more involved.
I do see some memo bloat. I have a table that stores configuration data. When packed, the .fpt is 1280 bytes. I see from the latest sent to me that it is up to 5,205,248 bytes. That is bigger than the source code.
Sincerely,
Gene Wirchenko