ODP: ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
>> where have you  run and got 0.078s? Tested in flamerobin. Now tested in ISQL – result: 0.003 sec NAME === Amsterdam Current memory = 37027264 Delta memory = 254320 Max memory = 37109808 Elapsed time= 0.003 sec Buffers = 2048 Reads = 21 Writes = 0 Fetches =

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread DougC d...@moosemail.net [firebird-support]
Mon, 04 Mar 2019 12:29:22 -0500 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote 04.03.2019 18:11, Mark Rotteveel mailto:m...@lawinegevaar.nl [firebird-support] wrote: > Claiming some must have done something really wrong without clear > evidence is not really

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
the vps is only for test,no extra connection to dbCPU is 0%,memory 60% If need I can give access to databases/vps thanks On Monday, March 4, 2019, 7:32:21 PM GMT+2, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 04.03.2019 18:11, Mark Rotteveel m...@lawinegevaar.nl

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.03.2019 18:11, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > In this case you must done something really wrong. > > Claiming some must have done something really wrong without clear > evidence is not really constructive. Yes, but without real data it is impossible to

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 4-3-2019 18:02, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 04.03.2019 17:57, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: >> yes > > In this case you must done something really wrong. Claiming some must have done something really wrong without clear

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
that's the change done: I've installed Firebird 3.0.4 x64, changes made in firebird.conf:    TcpRemoteBufferSize = 32767 WireCompression = true + restart firebird service On Monday, March 4, 2019, 7:03:06 PM GMT+2, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote:

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.03.2019 17:57, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > yes In this case you must done something really wrong. -- WBR, SD. ++

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
yes On Monday, March 4, 2019, 6:55:12 PM GMT+2, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 04.03.2019 17:39, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > As I mentioned in my first post I run that query for 15 times for each sever > FB,PG,mysql.  

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.03.2019 17:39, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > As I mentioned in my first post I run that query for 15 times for each sever > FB,PG,mysql. Are all of them installed and run on the same virtual host? -- WBR, SD.

Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Hi where have you  run and got 0.078s?As I mentioned in my first post I run that query for 15 times for each sever FB,PG,mysql.tested from 2 different computers/internet connectionswhy PG and mysql works fine? PG is almost x40 times faster? On Monday, March 4, 2019, 6:06:17 PM GMT+2,

ODP: [firebird-support] Turn on WireCompression on Firebird 3

2019-03-04 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
Hi. This is not Firebird issue. You must look into something between. For me first run is: Total execution time: 0.078s Second buffered is: Total execution time: 0.000s 3 seconds is really long time. There must be something involved between. 3 seconds on even 1RPM HDD is also long.. Regards,