J
Jon Skeet [C# MVP]
Bonj said:No! Because I didn't actually stop and think "oooh.., what's a million
divided by thirty?" ah - about thirty-three thousand... mmm., that looks
wrong. I just ran the query and didn't at the time see any reason why it
wasn't right.
*Anything* being compressed to 30 bytes is pretty unusual...
No, because I wasn't particularly bothered about the exact compression ratio.
Fair enough.
I don't know - I can't see the point in that. I want to find out exactly how
big it's getting compressed to *in the database* - and ideally, I want the
database to tell me this info.
Well, I'm sure there's a way that the database can tell you how many
bytes are in the blob - but finding out how much actual disk space that
means is a different matter. That sounds somewhat more advanced. Maybe
I'm misunderstanding you though.
OK, so it's obviously not 30 bytes. I see that now. But I've no doubts that
it's compressing it to at least some degree, probably in the region of
10%-25%, and come to that, I've no reason to believe its losing anything or
compressing it any less than the managed library would.
I suspect it's doing pretty much exactly the same as the managed
library would, to be honest. I'd still be interested to find out what
went wrong with the managed code though. If you find the actual code
which failed, please let me know.