Blogs

Blog Tags Help

Enter a tag to filter the current view
more
less
Combined feed for site

Domino Diva

An iSeries take on Domino

Previous |  Main  | Next

Impressed with 'Compress database design'

Kim Greene  

 I am very impressed with the new database property 'compress database design'.  I recently upgraded my test Domino server from 7.0.3 to 8.0.1 and played around with the 'compress database design' database property.  After doing a compact -c on the database to switch it to the new ODS, level 48, I saw this on the console:

 

Compacted mail/dadminis.nsf, 9472K bytes recovered (54%)

 

Here is a bit of a precursor to explain my test.  The mail file (dadminis.nsf) was using the Standard Mail 7 template.  It was still at ODS 43 after the upgrade.  The mail file only had 4 documents in it, so it was primarily comprised of design elements.  I set the notes.ini parameter Create_R8_Database=1 and restarted the server.  I did a 'load compact -c mail/dadminis.nsf' at the console, and got the above results, the 54% reduction in file size.

 

The size of the mail file (still the Standard Mail 7 tempate) went from 18 MB down to 8192 Kb.  Talk about a nice improvement for a base mail file.  Thank you to the Lotus team for this improvement!

 

Next on my target list is how much the database property 'compress document data' pays off.

Comments

1 Kim Greene      Permalink Wicked cool, I can see I have many more performance scenarios to test ... this is going to be fun!

2 Chris Whisonant      Permalink So you like it? :) The design compression is great, but the big improvement you'll see is with the document body data compression. But it's very much contingent on the amount of attachment data. David Jones wrote about his experience here:

http://www.bleedyellow.com/blogs/jonesy/entry/domino_8_0_1_compression

He saw 28% savings for his entire mail directory!! I've seen very similar in beta testing I've done. And at my client this week (who isn't at 8 yet), I told them about the compression stuff. One of the mail files I copied to my client was able to save only 9% - it was only 650 MB. But for a mail directory that adds up to 2.8 TB!, the compression savings will add up to a TON of space for them even if they can only get 15-20%...

Previous |  Main  | Next