New database dump smaller than old one

I installed RT 3.8.7 on a test server and loaded the database with a dump
the listed procedures to update the database for 3.8.7. A dump of the
resulting database is about 9.5 megabytes whereas the old database dump is
about 13 megabytes. I’ve gone through the new setup and everything seems
to be in place and functioning correctly. What could explain this
decrease in size? Compression that wasn’t done in 3.6.x?

David Griffith
dgriffi@cs.csubak.edu

A: Because it fouls the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?

Ours reduced by about 1gig. I am sure it is something to do with the more
efficient storage of binary files in (Binary Datatypes) Instead of
longtext/longblob.

I noticed also the backup takes less time to run… All is well and we have
no problems so I feel there is no cause for concern.On Wed, Dec 16, 2009 at 9:50 AM, David Griffith dgriffi@cs.csubak.eduwrote:

I installed RT 3.8.7 on a test server and loaded the database with a dump
from my production instance of RT (version 3.6.7). I then went through
the listed procedures to update the database for 3.8.7. A dump of the
resulting database is about 9.5 megabytes whereas the old database dump is
about 13 megabytes. I’ve gone through the new setup and everything seems
to be in place and functioning correctly. What could explain this
decrease in size? Compression that wasn’t done in 3.6.x?


David Griffith
dgriffi@cs.csubak.edu

A: Because it fouls the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com