[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] space saving in the database


In response to Marc Cousin <cousinmarc@xxxxxxxxx>:

[snip]
> 
> Still, I'd like to know if the md5 field is always a multiple of 32 bits in 
> length ?

md5 is _always_ exactly 128 bits.  It's frequently represented as a 32
character hex string, but that's just a friendly way to display it.

If you use a bytea field (for example) you can lock it in at 128 bits.
That will help overall by only taking up 20 bytes instead of 36 bytes
for the text string representation, but you have the 4-byte length
header either way.

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@xxxxxxxxxxxxxxxxxxxxxxx
Phone: 412-422-3463x4023

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilot Consulting.