mysql data compression

Question

I have some data in a few columns that repeat often from 40-80%.

Is there some way to have mysql do some kind of compression?

Gordon

I dont think you want to slow down mySQL like that; An important question is WHY would you want to? Perhaps there is another problem that needs solving instead. — Karl
– Karl, Commented Mar 22, 2011 at 22:58

duffymo · Accepted Answer · 2011-03-22 22:59:27Z

1

Repeating data? Sounds like you're breaking normalization rules. I'd investigate those before resorting to compression. How do you intend to query on compressed data? Not useful, in my opinion.

answered Mar 22, 2011 at 22:59

duffymo

310k46 gold badges376 silver badges571 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql data compression

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related