Additional note: Based on the MSC logs, “Checking list of deleted records…” is performed for every table in a 4D application. Only if there are a number of these deleted records to verify does it show in the MSC UI. We have an app with 300 tables (!). 30 to 40 show a progress bar during "Checking list of deleted records…” This is adding ~15+ minutes to a verify. I am not sure if having these hidden/deleted records is also negatively impacting app performance. Investigating…
Thanks, Kirk > On Oct 24, 2016, at 12:15 PM, [email protected] wrote: > > Thanks Arnaud, > > Currently none of our tables have the "Records definitively deleted” > unchecked - but that does not mean this attribute was not unchecked sometime > in the past. (I am Inheriting this application…) > > Interesting observation: I took three of our currently unused tables which > were showing the “Checking list of deleted records…” message during MSC > Verify. They were empty (no records). I truncated each table and ran MSC > Verify again. This time “Checking list of deleted records…" did not appear. > Obviously record headers (or sim) were left behind from a past delete. > > Thanks for your suggestion. It certainly sparked some ideas! > > Kirk > >> On Oct 23, 2016, at 3:47 AM, Arnaud de Montard <[email protected]> wrote: >> >> >>> Le 22 oct. 2016 à 19:34, [email protected] a écrit : >>> >>> Hi All, >>> >>> (Windows 2012, 4D v15.2, client/server, 80 Gb data file) Looking for ways >>> to enhance performance... >>> >>> Just curious: When running a verify on our data I see each table being >>> validated with a message similar to: "Checking list of deleted records…” >>> In some cases this step takes more than a minute to complete. Anyone know >>> what is happening during this verify and is it an indicator of some >>> problem? MSC tells us we don’t need to compact the structure or the >>> datafile… >> >> I don't remember having seen that message… At the same time, I've never >> unchecked the table property "Records definitively deleted": >> <http://doc.4d.com/4Dv15R5/4D/15-R5/Table-properties.300-2964251.en.html> >> Could it be related? >> >> -- >> Arnaud de Montard >> >> >> ********************************************************************** >> 4D Internet Users Group (4D iNUG) >> FAQ: http://lists.4d.com/faqnug.html >> Archive: http://lists.4d.com/archives.html >> Options: http://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:[email protected] >> ********************************************************************** > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
