Testing the compression?

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Testing the compression?

Jiří Činčura-2
Hi *,

anybody testing the compression:
http://blog.cincura.net/233572-compression-support-in-firebirdclient-beta/
?

If not, there's no point in holding the beta. I'll just release it and
let's see what happens [1]. I can't test it much more myself.

[1]: As it's said. You need to break an egg to make an omelette.

--
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: Testing the compression?

Gerdus van Zyl
I have run my application's test suite on Firebird 3 with and without compression and all seems OK.
Verified it's using compression by looking at the server version string returned by connection (ends with P13:Z).

Have also run tests with compression on high latency connection on database hosted on Azure.
The difference in transfer time is highly variable but the best case I saw was almost half; eg without compression 6 seconds vs 3.4s with compression.
Increasing the PacketSize and FetchSize to maximum 32767 also has a large positive impact on transfer time over internet connection.

Thanks.


On Mon, Sep 19, 2016 at 7:39 PM, Jiří Činčura <[hidden email]> wrote:
Hi *,

anybody testing the compression:
http://blog.cincura.net/233572-compression-support-in-firebirdclient-beta/
?

If not, there's no point in holding the beta. I'll just release it and
let's see what happens [1]. I can't test it much more myself.

[1]: As it's said. You need to break an egg to make an omelette.

--
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



--
------------------------------------------------------------------------
Gerdus van Zyl

------------------------------------------------------------------------------

_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: Testing the compression?

Jiří Činčura-2
> was almost half; eg without compression 6 seconds vs 3.4s with
> compression.

Yes. It also highly depends on data.

> Increasing the PacketSize and FetchSize to maximum 32767 also has a large
> positive impact on transfer time over internet connection.

Honestly I'm thinking about removing these two and using "the largest
reasonable value". Almost nobody knows about these and even less people
know what they are doing. And especially with PacketSize the bigger the
better, maybe unless you're running on 40MB RAM.

--
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: Testing the compression?

Jiří Činčura-2
In reply to this post by Gerdus van Zyl
And Thanks for testing BTW.

--
Mgr. Jiří Činčura
Independent IT Specialist


------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: Testing the compression?

Rick Roen-2
I've tried compression on a local and remote FB3 database and am not seeing any difference using compression or Packet/Fetch size.

Do I have settings correct:  On server: WireCompression = true
connection string: initial catalog=<>;compression=True;data source=<>;port number=3051;role name=Office;user id=<>;password=<>;character set=ISO8859_1;packet size=32767;fetch size=32767;

I have tried compression true/false and removed the packet and fetch size (so they default) and seen basically no difference.

Any suggestions?

Regards,
Rick

On Tue, Sep 20, 2016 at 6:15 AM Jiří Činčura <[hidden email]> wrote:
And Thanks for testing BTW.

--
Mgr. Jiří Činčura
Independent IT Specialist


------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

------------------------------------------------------------------------------

_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: Testing the compression?

Jiří Činčura-2
> Any suggestions?

To see any difference you need a lot of data and slow connection.

--
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider