photools.com Community

IMatch Discussion Boards => General Discussion and Questions => Topic started by: Ferdinand on May 29, 2014, 12:38:19 PM

Title: Database size - fresh DB vs converted DB
Post by: Ferdinand on May 29, 2014, 12:38:19 PM
As part of my efforts to resolve that non-editable description field bug, I created a replacement production database starting from scratch.  This was meant to replace the one that I had converted from 3.6.  Same files, same categories, keywords, attributes, thesaurus, etc.  The converted DB was 4.83Gb, the one started from scratch was 5.35Gb, or a little over 10% larger.

I was initially a little surprised by this, as I thought that they'd be reasonably close.  I guess the difference is in the image thumbs which are in the DB, as I understand it.  So converting the 3.6 thumbs gives me a smaller DB than creating them from scratch.

Is this to be expected?
Title: Re: Database size - fresh DB vs converted DB
Post by: Mario on May 29, 2014, 01:23:23 PM
Did you run a compact on both. The size difference may be from pre-allocated "grow" space. I really don't test such things so I'm just guessing.
Title: Re: Database size - fresh DB vs converted DB
Post by: Ferdinand on May 29, 2014, 01:25:27 PM
I certainly did.
Title: Re: Database size - fresh DB vs converted DB
Post by: Ferdinand on May 29, 2014, 05:26:48 PM
Quote from: Mario on May 29, 2014, 01:23:23 PM
The size difference may be from pre-allocated "grow" space.

Perhaps.  You'd know better than I.  I thought perhaps that V3.6 used more aggressive compression in creating the thumbs than V5, and the conversion just brings them across as is.  It's not a big deal.  I was just reporting an observation that took me by surprise.