On Wednesday 01 October 2008 16:21:45 Stewart Smith wrote: > On Tue, Sep 30, 2008 at 03:06:40PM +0900, Yoshinori Matsunobu wrote: > > The size was 2700MB. When I converted to local encoding (EUC-JP), > > the size was 2013MB. > > What if each of the text fields was gzipped? If using --fast option, > shouldn't have much of a performance penalty (and can possibly be a huge > win in caching). > > My theory is that compressed text fields give a bigger win than more > efficient encodings... but it's just a theory at the moment :)
Compression of small amount of data achieve negative compression, i.e. compressing a 12 Byte value can give a 36 Byte "compressed" result. _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
