> > application/vnd.rn-realmedia 9 3583755 3272342
>
> > The aggregate size of the blobs was 334,948,746. The blobs represent
>
> > The aggregate size of the compressed blobs was 271,077,508 bytes.
>
> > The elapsed time for the
> > uncompressed blobs was about 64 seconds, the elapse times for fetching
> > and decompressing the compressed blobs was about 58 seconds.
> >
> > The machine was 768MB 1.3GHz Athlon. The machine while decompressing
> > was, in the venacular, beat to shit.
> >
> > I'm losing my enthusiasm for compressed blobs. I'm not convinced the
> > big win is there.
>
> Did you test compression also "over the wire" or only as stored?
> The biggest part of this data couldn't be good compressed and is seen as

overhead, thus we can't

> expect much difference?
> Is decompression/compression time also included in these measurements?
> Still i think compression can be very usefull for a lot of data.

And what about "client decompression"?

Especially for text-based data (<cough>xml</cough>) this could be a winner.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com