Subject Re: [Firebird-Architect] Blob Compress -- Some Numbers
Author Miroslav Penchev
On Wed, 18 May 2005 09:40:12 +1000, Nigel Weeks <nweeks@...>
wrote:

> How would it go if compression of your blob happened as a background
> task?
>
> Store some meta-data about the blob somewhere, indicating whether or not
> it's been compressed.
>
> Blobs get written in full-size format to begin with. Then, as part of
> the
> sweep, or a cron job, or some other scheduled task, look for blobs that
> haven't been compressed, zip them up, and change the meta-data to suit.
>
> Just an idea.
>

The main idea of compressed blob was not to gain little more free space on
HDD. The main idea is to decrease the amount of reading date from "slow"
HDD by compressed data and by this way to gain in performance of server
and client (also reducing data transferred on the wire).

Cheers,
--
Miroslav Penchev