MySQL Forums
Forum List  »  Falcon

Re: More details on compression wanted
Posted by: Jim Starkey
Date: January 24, 2007 03:09PM

I actually did some experimentation with that last year. The bottom line is that even with a fast, multi-core, 64 bit processor, the disk could fetch pages faster than the processor could decompress. And worse, the processor could be doing something useful while the disk was doing its thing. And even worse, JPEGs and PDFs are already compressed, so the whole compression effort reaped no benefit.

Somebody needs to find or invent a lower overhead compression scheme suitable for databases. I'd be willing sacrifice amounts of compression to be blindingly fast.

That said, the Falcon encoding results in a record smaller than a run length encoded record, so the term "compression" doesn't bother me much. But personally, I use the word "encoding".

Options: ReplyQuote

Written By
Re: More details on compression wanted
January 24, 2007 03:09PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.