Hi,

> 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.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info