Thanks, I think I get it. Nasty of them to create so much work for us!
If I understand, you are comparing PersonTable.EditDate with LinkTable.extDate. What's the LinkTable.Modified flag for? And EditDate must be when I edited the record, not a date where I merely looked at in the FS Central comparison.
I have just over 16500 records in LinkTable and they ALL have the extDate = 0.0. Only 1100 of those have Modified = 0.
And I have about 17800 records in PersonTable and the EditDates are all > 0.0. Meaning in part that all but about 1300 of my people are matched up.
So theoretically, every single person who is linked to a FSFT ID should be in the list to be checked in Family Search Central. But I just processed a few hundred more yesterday and they are no longer in the list. Is that what the Modified does? The ones still to be checked are those with Modified = 1 which is about 14400 records?
And if I reset the count through the GUI does that make all the Modified = 0? At least until such time as I give Central the opportunity to go scanning and comparing the date fields.
I ask because I don't really want to go messing with the tables unless I know what I'm doing <grin> and at the moment I appear to have a TON of work to do!