The Tag Manager did remove some rows ...

[sinus]

Hi all
I used today with the new release 5.2.0.12 the new Tag Manager and added only some fields to the defaults.
I think, about 12 additional Nikon-fields, all other groups and fields I left, like Mario did "pre-installed".

I checked this preferences with some images (from different years, with different cameras - ups, I had once even a Olympus CL2500  ) and then I let run the diagnostics.

All went fine, two errors, what IMatch did repair, and as you can see in the log below, IMatch trimmed out against 19 Millions rows.
Not that bad. I will let run the "Compact and optimize" - tool, but not know, because this will take one hour or so and I have not more the time.   

Wanted only, that you can see, what we can save with this new Tag Manager.
BTW: I was always a bit worried, to write too much in the Attributes for example, because all takes space, but now, when I look at 19 Millions rows, I am a bit more relaxed 

IMatch database diagnosis logfile created: 08.11.2014 20:17:37
Application Info:
    Version:                      5.2.0.12
    Filename:                     C:\Program Files (x86)\photools.com\IMatch5\IMatch5.exe

General Database Info:
    Database file name:           C:\sinus_db_IM5\SINUS-IM5.imd5
    Database file size on disk:   9.37 GB
    Number of folders:            545
    Number of files:              169'771
    Number of categories:         6'340
    Clearing oid cache.

Checking files:
    Performing sort array maintenance:
Completed.

Checking folders:

...

Completed.

Checking file history:
      Entries:  409'626
Completed.

Checking time line:
      Entries:  5'546
Completed.

Checking Metabase:
      Warning: 2 files marked as pending for write-back which have no data to write-back. Fixed.
Completed.

Checking Cache:
    89'054 files in cache folder.
Completed.

Checking Annotation Objects:
      Containers:  0
Completed.

Checking Visual Query Data:
      Data items:  663'556
Completed.

Checking Favorites:
Completed.

Trimming Tag Data:
Completed in 3269s. 18'985'089 rows removed.
    Clearing oid cache.

Analyzing database:

Optimizing Database, rebuilding optimial index structures and query plans:
Completed.

WriteTest:
Completed.

Results:
    Errors:    0
    Warnings:  1

IMatch database diagnosis logfile closed: 08.11.2014 22:01:05 (01:43.28)

[Mario]

Very good. You should experience a better performance for all metadata-related features, e.g. search, filters, data-driven categories and such.

The biggest chunks of data in an IMatch database are the thumbnails (naturally) and the metadata. Without the new behavior, a typical NEF file had between 400 and 800 (!) metadata tags in the database. One file! Now we have maybe 200-300, including XMP and everything else.

[sinus]

Yep, and BTW, the database-size is now about 8 GB instead 9.8 GB.