Re: [Firebird-net-provider] Testing the compression?

2016-09-20 Thread Jiří Činčura
> 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 F

Re: [Firebird-net-provider] Testing the compression?

2016-09-20 Thread Rick Roen
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;

Re: [Firebird-net-provider] Testing the compression?

2016-09-20 Thread Jiří Činčura
> 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

Re: [Firebird-net-provider] Testing the compression?

2016-09-20 Thread Jiří Činčura
And Thanks for testing BTW. -- Mgr. Jiří Činčura Independent IT Specialist -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.

Re: [Firebird-net-provider] Testing the compression?

2016-09-20 Thread 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 o

[Firebird-net-provider] Testing the compression?

2016-09-19 Thread Jiří Činčura
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