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 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, 2019, at 8:12 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> 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 again and notice 4D
>> spending a - very - long - time verifying that table. Looking at the verify
>> log I notice a few, but not all, tables with this message listed by them.
>> 
>> The table property "Records are definitively deleted" is not checked for
>> [email_que]. At least one other table with the message do have it checked.
>> 
>> I have to assume it's connected with the the large selection that was
>> deleted. But given that I would expect a repair/compact operations to have
>> resolved it.
>> 
>> Anyone else run into this?
>> 
>> Thanks
>> -- 
>> Kirk Brooks
>> San Francisco, CA
>> =======================
>> 
>> *We go vote - they go home*
>> **********************************************************************
>> 4D Internet Users Group (4D iNUG)
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **********************************************************************
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **********************************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to