>>Hi all,
>>
>>we have a file on the customer site that hits the 2gb limit every so often. The dbf and cdx are fine, it is the FTP that hits the limit. when this happens the ftp seems to clear itself out and hold no data. I can restore from a backup and they might lose half a days details, not good but it's something. What gets me is that when I restore from a backup and pack the file the FTP shrinks to 150-180mb. I don't lose any data, there just seems to be huge bloat in the file. I use the insert command to populate the file but it's a log file, it is never updated or modified after the fact. Any ideas what might be causing this?
>>
>>~M
>
>Hi Mark,
>
>I don't use FPT files for .DBF files. Because when you run a replace command FPT files can't replace, add end of the file. So FPT files sizes easly increase.
>
>I create a .dbf file like this:
>key int,
>mymemo c(40)
>
>I unchain my memo string and chain this mymemo fields instead of use FPT files so I don't have any trouble...
A handy solution, but the memo fields are well locked into the table at this point!
~M