Streams in CLS SQL Functions - 2005
-
I am trying to use System.IO.Compression to compress/decompress the buffer. I have the data in byte format in sql server and I need to create an CLR user defined function. I have everything running except that for some of the files, the compressed size is larger than the actual file size. I tried to use both Deflate and GZip compression types. Did anyone face the similar situation. Thanks in advance for your help.:confused: Thanks Bhaskara
-
I am trying to use System.IO.Compression to compress/decompress the buffer. I have the data in byte format in sql server and I need to create an CLR user defined function. I have everything running except that for some of the files, the compressed size is larger than the actual file size. I tried to use both Deflate and GZip compression types. Did anyone face the similar situation. Thanks in advance for your help.:confused: Thanks Bhaskara
If you try to compress a file that is already compressed (like zip, jpg, mp3, mpeg, wmv, etc.) you may end up with a file that is larger than the original, as the file can't be compressed further and the compression adds metadata. -- modified at 18:27 Tuesday 16th May, 2006 Note: GZip uses the same algorithm as Deflate, so you won't see any noteable differences in file size between them. --- b { font-weight: normal; }