INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: Cmagic on July 30, 2003, 11:21:04 pm

Title: To Matt - out of curiosty: mediafiles.jmd size
Post by: Cmagic on July 30, 2003, 11:21:04 pm

Hi Matt,

I just noticed that in MC9.1 the size of the mediafiles.jmd file (the main database file) has been reduced by approx 50% from its previous size in MC9.0.

Is it a side effect of better unicode management or just something else ?

Thanks and have a great day,

Christian

Title: Re: To Matt - out of curiosty: mediafiles.jmd size
Post by: Matt on July 31, 2003, 05:46:47 am

The database is stored (both in memory and on disk) as UTF-8 instead of UTF-16 now.  That means half the disk space and half the memory with 9.1 if you don't use many international characters.

It introduces a decoding step but since it's working with so much less memory the overall speed is still better than before.

Thanks Christian.

Title: Re: To Matt - out of curiosty: mediafiles.jmd size
Post by: Cmagic on July 31, 2003, 08:31:25 am

Thanks Matt,

It's good to know MC takes care of the PC ressources even if memory and disk space are quite affordable these days.

C.

Title: Re: To Matt - out of curiosty: mediafiles.jmd size
Post by: nila on July 31, 2003, 04:32:34 pm

Just a qu I had about the db.

Is it a totally flat db?
If I'm creating a lot of custom fields to use for some of my files but these fields are only being used by say 1% of my files (around 200 files) - is this making the db/memory useage a lot higher?

Title: Re: To Matt - out of curiosty: mediafiles.jmd size
Post by: Soundman on July 31, 2003, 06:54:55 pm

Quote

The database is stored (both in memory and on disk) as UTF-8 instead of UTF-16 now.  That means half the disk space and half the memory with 9.1 if you don't use many international characters.

Matt, I just wanted to say, "Thank You" for this change.  I freqently copy my Library over a slow link, and this helps a lot.  Even when .ZIP'd the size has reduced by around half, more like MJ8.  Thanks!

Title: Re: To Matt - out of curiosty: mediafiles.jmd size
Post by: Matt on July 31, 2003, 07:24:50 pm

Quote

If I'm creating a lot of custom fields to use for some of my files but these fields are only being used by say 1% of my files (around 200 files) - is this making the db/memory useage a lot higher?

No it isn't.  The database uses memory only for real data -- not for spaces where data could go.

Title: Re: To Matt - out of curiosty: mediafiles.jmd size
Post by: nila on August 01, 2003, 12:02:13 am

cool cool :)