On 15 Jul 2008 06:49:19 -0700,
Post by Jason L. Froebe [TeamSybase]
Post by Jason L. Froebe [TeamSybase] Post by Jason L. Froebe [TeamSybase]
let me know if you have any other questions that aren't
covered on the blog :)
with compression = x -> "You need to understand that
whenever you dump a database to a file using this syntax,
there are three volumes that are dumped"
What does this mean?
three volumnes are not dumped with compress:: method?
what do you mean by volumes in this dump context?
The 'compress::' method will compress the entire data stream. You can actually
use the zlibrary (http://www.zlib.net) and uncompress the file.
The 'with compression' will create a file consisting of three parts (IOW:
volumes). The first two parts consist of meta-data that are relevant to the
dump file - these are NOT compressed. The third part is the data stream (your
database) which is compressed.
Both mechanisms use the zlibrary. There really isn't any performance difference
between the two. The "with compression" method does create a slightly larger
file (a few kilobytes) but that's so tiny to be insignificant.
I'm not sure if 'compress::' will be officially deprecated this year but it
should be soon.
Jason L. Froebe