https://doc.4d.com/4Dv17/4D/17/Compact-page.300-3743562.en.html
check out "Compact address table"
> 2019/01/13 1:29、Spencer Hinsdale via 4D_Tech <4d_tech@lists.4d.com>のメール:
>
> Isn’t there an option for Compact to drop Address Tables? This invalidates
> any Log Files but gives table(s) a clean
If it is just one table you can export the records, TRUNCATE TABLE, and import.
This is basically a one table compact and resets the address table too.
> On Jan 12, 2019, at 11:29 AM, Spencer Hinsdale via 4D_Tech
> <4d_tech@lists.4d.com> wrote:
>
> Hi Kirk,
>
> Isn’t there an option for
Hi Kirk,
Isn’t there an option for Compact to drop Address Tables? This invalidates any
Log Files but gives table(s) a clean start. There is a function like Table
Fragmentation which returns ratio of remaining record to total address table.
Sorry not at computer...
Spencer
> On Jan 12,
A few months ago a bug resulted in a large number of records being created
in a table ([email_que]) by mistake. Bug was fixed and 1 or 2 million bogus
records were deleted.
Since then the data file has been verified and compacted at least once.
Just now I was running a verify on the data file
4 matches
Mail list logo