Unexpected results when Copying database and the deleting large # of people

RootsMagic
1

I am aware that I can use drag n drop – for this purpose copied the database in Windows / renamed and then opened in RM.
I then deleted a large # of people 26K to 6K (over 75% less people)
I also ran all tools – the file size remained the same (slightly bigger actually)
Approx 210mb.

I do realize them sources/ places and media tables etc would remain the same.
I would have expect due to the large # of facts/people etc – the file size would be noticably smaller.

I then used a drag drop method which the file size was 66mb.
I would not expect the file size of the first method to be as smaller as the drag n drop method but also I would not have expected the file to be no change in file size. This seems odd to me. (I am sure Media thumbs have large part of that – but there is more going on.

Kevin

2

Does the Enhanced properties list Tool jive with the original or the trimmed database?

3

The original original db has many more of course
The Trimmed db and the drag n drop db have 99.9% match on people/events and and other info. (about 6.2K people and 20K evens vs 26K people and~83K events for orig)
Not for places/ sources/citations which is expected. (as 20K people were removed from the orig)

Kevin

4

That certainly makes for a reportable test case if the file size remained the same (slightly bigger actually)

5

More info using sql
Select "PersonTable" as "Table", Count(PersonID) as Qty FROM PersonTable UNION Select "EventTable" as "Table", Count(EventID) as Qty FROM EventTable UNION Select "MediaTable" as "Table", Count(MediaID) as Qty FROM MultiMediaTable UNION Select "PlaceTable" as "Table", Count(PlaceID) as Qty FROM PlaceTable

full original

image
image194×157 2.02 KB

Removed people same file size 210 mb

[image]

image
image169×126 1.91 KB

Drag N drop (71Mb)

[image]

image
image188×130 1.9 KB

6

You have to run the RM Compact database tool to recover space formerly used by deleted records.

Deleting people does not delete many things associated with them, e.g., Places, Citations, Sources, Media, … but should remove links to same.

Edit: drag’n’drop or GEDCOM only transfers things that are used by the people included.

7

as stated I ran all tools – its did not reclaim space – I expected to need to run tools.

image

8

I am aware of that.

Update I ran the tools a 2nd time – this time it was reduce by 10% (only 10%) to 190mb
Since Places and media was not reduce by delete only people and facts that would account for chunk of it. (not sure how much the thumbs take up).

  • original file 210 mb
  • 2nd file 190 mb
  • drag n drop 71 mb (was smaller before restoring media links)