Score:0

Changes in compression rate

jp flag

Every month I usually compress all my database dumps into a rar file.

I was very happy with the compression rate, as each compressed file was usually about 30MB, with a compression rate of 99%.

Since a few weeks ago, without having touched anything (neither in the compressor parameters nor in the dump system), the compression rate has dropped to 70% and now the compressed file occupies about 1.50GB.

Any idea why this is happening?

Thanks!

djdomi avatar
za flag
you may try with xz if it gets better ratio imho
Score:1
ar flag

This is probably happening due to the database containing less compressible stuff.

Generally the level of compression depends on the context. Pure text (e.g. a natural language) compresses really well, while already compressed formats such as JPEG or PNG doesn't compress at all.

You should look into what content you have in your database, and how the various content types are affected.

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.