This doesn’t strike me as "big".
2)I use the SqlServer ( varchar(max) ) to store the string.SQLServer should have not trouble handling those strings.
3)I just compress common string ,eg.:...Any of the suggested compression alternatives should work for you. Based on the example you provide I assume that you will obtain excellent compression ratios.
I would like to draw your attention to one more alternative: RLE which stands for Run Length Encoding. It doesn’t give you a great compression ration but it’s very simple and therefore fast. I have found a Perl implementation for it which can be found here (I did not tested it though)
In reply to Re^3: How to "zip" a big string to small ?
by dHarry
in thread How to "zip" a big string to small ?
by pysome
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |