Posted 20 May 2014 - 01:29 PM
While I cannot account for the discrepancies of 8 people and 6 families between the Database Properties report and your GEDCOM export, I am not surprised and can advise that there are many more potential discrepancies. The program report is simply a count of records in each primary table, whether a record is used or not. After deletions and mergings, there can remain a variety of records that are no longer used "phantoms" because RootsMagic is lazy about cleaning up the detritus. Some, but not all, types of phantoms are cleaned up by the Database tool. Places become unused and can be removed from within the Place List manager. But facts may remain for non-existent persons, citations for non-existent persons and facts, likewise for media links and WebTags. It takes an export/import or drag'n'drop to a new database to strip these out.
As to your second question, I think I recall correctly that RootsMagic 3 and earlier and Its predecessor Family Origins re numbered people to fill holes when the database Compact utility was run. However that was a consequence of the database engine which flagged records for deletion, hiding them from the user as though they no longer existed until Compact was run to actually remove them - the database table automatically re numbered the rows, therefore, revised record numbers. SQLite, the db engine in RM4+, operates differently - records are immediately deleted but the record numbers remain unchanged, I.e., they are fixed, independent of the number of preceding rows. The current Compact operation merely frees up storage space occupied by deleted rows; its actual name in SQLite is Vacuum, for good reason, because it is not the Compact operation of xBase engines.
I, too, would not want my database to be re numbered to fill holes in the RIN sequence and objected to the Compact behaviour of RM3 and earlier. While I do not base my filing system on RIN, I have come to remember record numbers for a few important ancestors and find that handy when using RootsMagic explorer, alt+R is the fastest search path to a person. So I'm content with having a Compact that does not renumber.
Tom user of RM7550 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com
wiki, exploiting the database in special ways >>> app, a bundle of RootsMagic utilities.