BTW, the reason I say I'd have to see the performance regression, is that I suspect compression of UTF8 would allow us to save space (especially with variable-sized buffers) and consume more CPU, which currently drizzle is not CUP-intensive.
Baron Schwartz wrote: >> You can set UTF8 as default, but leave open the chance for people to >> use other character sets. > > Given the current limitations of fixed-size buffers for sorting, > group-by, and for internal temp tables (MEMORY engine) I would not set > utf8 as the default anyway -- performance cost is too high. Although > I understand the variable-sized MEMORY patches have been integrated? > > Still, filesorts will suck if everything is just automatically utf8. > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
