Hi.

 I've installed Firebird 3.0.4 x64 on VPS,and got slow performance with our app

 changes made in firebird.conf:

    TcpRemoteBufferSize = 32767

WireCompression = true

+ restart firebird service

in client connection (.NET connector): I put 

   Compression=True

I have zlib1.dll in app folder   

I've installed also mysql 8 and postgres 11(with default configuration ),and setup a simple table with 10 records for each

CREATE TABLE city (

  ID bigint NOT NULL,

  Name CHAR(35) NOT NULL,

  PRIMARY KEY (ID)

); 

INSERT INTO city VALUES (1,'Kabul');

INSERT INTO city VALUES (2,'Qandahar');

INSERT INTO city VALUES (3,'Herat');

INSERT INTO city VALUES (4,'Mazar-e-Sharif');

INSERT INTO city VALUES (5,'Amsterdam');

INSERT INTO city VALUES (6,'Rotterdam');

INSERT INTO city VALUES (7,'Haag');

INSERT INTO city VALUES (8,'Utrecht');

INSERT INTO city VALUES (9,'Eindhoven');

INSERT INTO city VALUES (10,'Tilburg');

I've run this query for 15 times on every server:

SELECT first 1 name from city where id=5 (fb)

select name from city where id=5 limit 1 (mysql+pg)

 and got this result:

firebird:    3.0822 sec

postgres : 0.0754 sec

mysql:      0.0874 sec

as seen fb is much slower,with or without WireCompression I see no change the result is identical,seems to me that WireCompression is not turned on

any help there?

thanks