How to compress huge tables? (more than 1M characters)

Oh, I see.
Well then you can try make sure not to add much values to the data as possible.

Btw you can use ProfileService its a great module it have datastore2 too. It might help alot.