Subject Re: [firebird-support] Firebird 3 compression data
Author Carlos H. Cantu
Post date 2015-09-28T11:48:35Z
Re: [firebird-support] Firebird 3 compression data Hi!

Look at firebird.conf for the parameter WireCompression.

Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br


Hello Carlos

Thank you for your answer.

In your article you has written about the benchmark with and without compression.

How you did that?

You have "FB 3 padrao" and "FB 3 compressao".

If I want to compare FB 3 against MySQL, Postegre, or whatever: how I can have compression enabled or disabled?

Thanks in advance.

Greetings.

Walter.


On Sun, Sep 27, 2015 at 8:33 PM, 'Carlos H. Cantu' listas@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
 
My article at fbnews talks only about wire protocol compression.

I guess you are talking about data compression on the database file, right? If so, afaik, some "new" algorithms are being tested/benchmarked and may be available in FB in the future, resulting in a better compression than the actual "RLE", but I guess it will not be in FB 3.0

Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br



According to this (very good) news,

http://www.firebirdnews.org/firebird-3-protocol-benchmark/

Firebird 3 can have compression of data.

Excellent!!!

However neither in the above page neither in the "Firebird 3.0 Release Notes"

http://web.firebirdsql.org/download/prerelease/rlsnotes/Firebird-3.0.0_Beta2-ReleaseNotes.pdf

says how to compress data. Just that was implemented by Alex Peshkov.

So, the evident question is:

How to have data compressed?

Of course, I am talking about Firebird 3.

Greetings.

Walter.