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
**********************************************************************

Reply via email to