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