ODP: ODP: [firebird-support] Turn on WireCompression on Firebird 3
>> 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 = 255 Second run NAME === Amsterdam Current memory = 37027264 Delta memory = 0 Max memory = 37109808 Elapsed time= 0.002 sec Buffers = 2048 Reads = 0 Writes = 0 Fetches = 9 Regards, Karol Bieniaszewski
ODP: ODP: [firebird-support] Silly selection problem ...
>>Can you explain how? I do not study your topic much and i can be wrong here. But maybe you got the idea about what i am thinking about. SELECT (SELECT PRE.ITEM_CONTENT_ID FROM FISHEYE_GALLERY_IMAGE_MAP PRE WHERE PRE.GALLERY_CONTENT_ID = :parent_id AND PRE.ITEM_POSITION < FGIM.ITEM_POSITION ORDER BY PRE.ITEM_POSITION DESC ROWS 1) AS PRE_ITEM_CONTENT_ID , (SELECT POST.ITEM_CONTENT_ID FROM FISHEYE_GALLERY_IMAGE_MAP POST WHERE POST.GALLERY_CONTENT_ID = :parent_id AND POST.ITEM_POSITION > FGIM.ITEM_POSITION ORDER BY POST.ITEM_POSITION ASC ROWS 1) AS POST_ITEM_CONTENT_ID FROM FISHEYE_GALLERY_IMAGE_MAP FGIM WHERE FGIM.ITEM_CONTENT_ID = :content_id Regards, Karol Bieniaszewski
[firebird-support] Re: Fw: Connect Firebird Database with Entity Framework model - Connection Failed
Kathir wrote: > I want to connect the Firebird database with Entity Framework > Model. Completed the successful installation and created the > database. But, I am facing some issues while connecting the firebird with > entity model. > * Updated the values like below. But facing the issue ‘Unable to load dll > ‘fbembed’ ’ > * Now I updated the client library ‘fbclient.dll’ in advanced option like > below > * But, now I am facing the error ‘Index was outside the bounds of the array’ [etc.] This is really the wrong forum for your problem. The quoted error is coming from your client, not from Firebird. Post your problem on the firebird-net-provider forum on Google groups: https://groups.google.com/forum/#!forum/firebird-net-provider HB
[firebird-support] Control services error 1062 - when stopping the service
Hi, I was running Firebird 2.5.4 on an internal Windows 2012 R2 server and noticed a couple of instances of the error message "Control services error 1062" in the firebird.log file. As I was about to upgrade to 2.5.8, I stopped the service and this also seemed to generate this message. I proceeded to upgrade to Firebird 2.5.8 (x64) and noticed that this message is still generated whenever I stop the service. Is this expected? If not, is it a cause for concern? I haven't been able to find the meaning of this particular error. Any info or suggestions would be greatly appreciated. Regards,Ed
Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3
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 constructive. Yes, but without real data it is impossible to say what's wrong. My crystal ball is not good enough for that. Then it would be much better to just stay out of the conversation.
Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3
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 [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 say what's wrong. My crystal ball is not good enough for that. May be increasing of network buffer size was an error, may be RAM was exhausted by already run PG and MySQL, may be ICU library is missing or may be client-side tool used for query execution is not suitable for high-latency network. Too much variants. I already suggested to use system monitoring tools but it is perhaps too complex for the author. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3
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 say what's wrong. My crystal ball is not good enough for that. May be increasing of network buffer size was an error, may be RAM was exhausted by already run PG and MySQL, may be ICU library is missing or may be client-side tool used for query execution is not suitable for high-latency network. Too much variants. I already suggested to use system monitoring tools but it is perhaps too complex for the author. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3
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 evidence is not really constructive. Mark -- Mark Rotteveel
Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3
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: 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. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3
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. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3
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. Are all of them installed and run on the same virtual host? -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3
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. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: ODP: [firebird-support] Turn on WireCompression on Firebird 3
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, Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] wrote: 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, Karol Bieniaszewski
Re: ODP: [firebird-support] Silly selection problem ...
On 04/03/2019 15:56, Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] wrote: > You can do this without window function also in FB<3, but less efective. > Do simple 2 subselects in your select. Can you explain how? Without the full window scan LAG and LEAD gave NULL ... -- Lester Caine - G8HFL - Contact - https://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve - https://enquirysolve.com/ Model Engineers Digital Workshop - https://medw.co.uk Rainbow Digital Media - https://rainbowdigitalmedia.co.uk
ODP: [firebird-support] Turn on WireCompression on Firebird 3
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, Karol Bieniaszewski
ODP: [firebird-support] Get client-IP-Adress
There is nothing built in. Think about. You can connect to client 1 through RDP and on the client 1 run another RDP to client 2 maschine, and from this maschine another RDP to client 3…. Where you do connection than this is the client. As say by others you must do outside logic self, and store info in some context variable or something like this. Regards, Karol Bieniaszewski
ODP: [firebird-support] Silly selection problem ...
You can do this without window function also in FB<3, but less efective. Do simple 2 subselects in your select. Regards, Karol Bieniaszewski
[firebird-support] Are SP/Trigger variables NULL on start?
Hello all, can I safely assume that all local and RETURNS variables are already initialized to NULL when my Stored Procedure (or Trigger) starts? Or do I need to treat them as "undefined" (as in Pascal/Delphi) and initialize them myself? Regards Stefan -- Stefan Heymann, Tübingen, Germany ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Turn on WireCompression on Firebird 3
04.03.2019 10:44, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > there other server tweaks to improve the performance for my case? First of all you must define "your case" and find bottleneck by using system monitoring tools. Usual reason for Firebird being slow in virtual machine is bad disk drivers. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Turn on WireCompression on Firebird 3
got "WI-V3.0.4.33054 Firebird 3.0/tcp (WIN-CNVKF3V883H)/P13:Z",so compression
is enabled
there other server tweaks to improve the performance for my case?
thanks
On Monday, March 4, 2019, 11:12:45 AM GMT+2, Mark Rotteveel
m...@lawinegevaar.nl [firebird-support]
wrote:
On 4-3-2019 10:06, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I'm using latest version 6.5.0
> found no isc_database_info item isc_info_firebird_version;
> in FbConnection.ServerVersion.
That is not what I meant... The request to Firebird server is done using
the isc_database_info operation, requesting information item
isc_info_firebird_version. This is done behind the surface by the
Firebird ADO.net provider when it opens a connection. The value is
returned from the property ServerVersion of your connection.
For example the code on my machine prints "WI-V3.0.4.33054 Firebird
3.0/tcp (Ramona)/P13:Z" which means compression is enabled:
var connectionString = new FbConnectionStringBuilder
{
Database = @"D:\data\db\fb3\fb3testdatabase.fdb",
UserID = "sysdba",
Password = "masterkey",
Compression = true
}.ToString();
using (var connection = new FbConnection(connectionString))
{
connection.Open();
Console.WriteLine(connection.ServerVersion);
}
Mark
--
Mark Rotteveel
Re: [firebird-support] Get client-IP-Adress
On 4-3-2019 10:04, josef.gschwendt...@quattro-soft.de [firebird-support]
wrote:
> with our client software installed on a terminal server we like to get
> the IP-Adress of the "real" client-computer connected to the database
> (the one the user sits in front of).
>
> With Mon$Remote_Address from Mon$Attachments (using FB 2.5.8) we get the
> IP-Adress of the Citrix-machine.
>
> Is there a way to get the IP-Adress of the client-machine.
> Is there a difference/improvement using FB 3?
From the perspective of Firebird, the Citrix machine **is** the client.
The fact that the user remotes into the Citrix machine makes no
difference to Firebird, as the Citrix machine is what makes the actual
connection.
So, no there is nothing built-in in Firebird to do this automatically
(and I don't think there never will be). If you want something like
that, your application needs to take care of that itself (eg by setting
a variable in the USER_SESSION context).
For example, your application will need to obtain the client IP address
in some way (I don't know Citrix, so I don't know if and how that can be
done), then after connect, it needs to execute:
select RDB$SET_CONTEXT('USER_SESSION', 'CITRIX_CLIENT_IP', '') from RDB$DATABASE
Subsequently, other parts of your application can get this using
select RDB$GET_CONTEXT('USER_SESSION', 'CITRIX_CLIENT_IP') from RDB$DATABASE
See also
https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-functions-scalarfuncs.html#fblangref25-functions-workcontext
Mark
--
Mark Rotteveel
Re: [firebird-support] Get client-IP-Adress
Hello Josef, > Hi, > > > with our client software installed on a terminal server we like to get the > IP-Adress of the "real" client-computer connected to the database (the one > the > user sits in front of). > > > With Mon$Remote_Address from Mon$Attachments (using FB 2.5.8) we get the > IP-Adress of the Citrix-machine. > > > Is there a way to get the IP-Adress of the client-machine. > Is there a difference/improvement using FB 3? One work-around that comes to mind is using context variables. E.g. upon client application startup, set the client IP address as a USER_SESSION context variable, which then is available in context of the client connection / user session in e.g. triggers etc. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
Re: [firebird-support] Turn on WireCompression on Firebird 3
On 4-3-2019 10:06, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I'm using latest version 6.5.0
> found no isc_database_info item isc_info_firebird_version;
> in FbConnection.ServerVersion.
That is not what I meant... The request to Firebird server is done using
the isc_database_info operation, requesting information item
isc_info_firebird_version. This is done behind the surface by the
Firebird ADO.net provider when it opens a connection. The value is
returned from the property ServerVersion of your connection.
For example the code on my machine prints "WI-V3.0.4.33054 Firebird
3.0/tcp (Ramona)/P13:Z" which means compression is enabled:
var connectionString = new FbConnectionStringBuilder
{
Database = @"D:\data\db\fb3\fb3testdatabase.fdb",
UserID = "sysdba",
Password = "masterkey",
Compression = true
}.ToString();
using (var connection = new FbConnection(connectionString))
{
connection.Open();
Console.WriteLine(connection.ServerVersion);
}
Mark
--
Mark Rotteveel
[firebird-support] Get client-IP-Adress
Hi, with our client software installed on a terminal server we like to get the IP-Adress of the "real" client-computer connected to the database (the one the user sits in front of). With Mon$Remote_Address from Mon$Attachments (using FB 2.5.8) we get the IP-Adress of the Citrix-machine. Is there a way to get the IP-Adress of the client-machine. Is there a difference/improvement using FB 3? Thank you for your help. Josef
[firebird-support] Fw: Connect Firebird Database with Entity Framework model - Connection Failed
Hi All, I want to connect the Firebird database with Entity Framework Model. Completed the successful installation and created the database. But, I am facing some issues while connecting the firebird with entity model. * Updated the values like below. But facing the issue ‘Unable to load dll ‘fbembed’ ’ * Now I updated the client library ‘fbclient.dll’ in advanced option like below * But, now I am facing the error ‘Index was outside the bounds of the array’ Could you please help me to get rid of these issues and get a successful connection? Is there any detailed document available for this? For your information, find the additional details below. - Firebird v3.0.4 - Firebird client v4.10.0.0 - DDEX provider version 3.0.2.0 - Visual Studio 2015 I followed the steps as suggested in this link. But I choose 'Embedded Server' as server type.https://firebirdsql.org/file/documentation/reference_manuals/fbdevgd-en/html/fbdg30-efw-vs-prepare.html Also, I tried with the latest Firebird client version (v6.4.0). But, Now even ‘Firebird Data Sources’ was not listed in the Data Sources list. Regards, Kathiresan S. [Non-text portions of this message have been removed]
Re: [firebird-support] Turn on WireCompression on Firebird 3
HiI'm using latest version 6.5.0 found no isc_database_info item isc_info_firebird_version; in FbConnection.ServerVersion. thanks On Monday, March 4, 2019, 10:52:43 AM GMT+2, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 4-3-2019 08:13, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > 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 The WireCompression setting does nothing for the server. It is a fbclient-only setting, and generally clients do not read the firebird.conf of the server. > in client connection (.NET connector): I put > Compression=True > I have zlib1.dll in app folder Firebird's zlib1.dll is not used by the Firebird ADO.net provider, it has the compression built-in. Also, which Firebird ado.net provider version? Support was introduced in 5.5.0 IIRC. In any case, your question might be more suitable for the firebird-net-provider Google group. > 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'); Unrelated to your problem, but if this is meant to be the Dutch city that is the seat of government, then it is Den Haag (or 's-Gravenhage if you prefer the old-fashioned name). > 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.082 2 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? I'm not sure this can be taken as an indication that wire compression is enabled or not. In Firebird 3, to determine this you can check the isc_database_info item isc_info_firebird_version; which is exposed in Firebird ado.net on FbConnection.ServerVersion. For example, when compression is not enabled, it will return: WI-V3.0.4.33054 Firebird 3.0/tcp (Ramona)/P13 When it is enabled, it will return: WI-V3.0.4.33054 Firebird 3.0/tcp (Ramona)/P13:Z (Z for zlib) Mark -- Mark Rotteveel
Re: [firebird-support] Turn on WireCompression on Firebird 3
On 4-3-2019 08:13, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > 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 The WireCompression setting does nothing for the server. It is a fbclient-only setting, and generally clients do not read the firebird.conf of the server. > in client connection (.NET connector): I put > Compression=True > I have zlib1.dll in app folder Firebird's zlib1.dll is not used by the Firebird ADO.net provider, it has the compression built-in. Also, which Firebird ado.net provider version? Support was introduced in 5.5.0 IIRC. In any case, your question might be more suitable for the firebird-net-provider Google group. > 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'); Unrelated to your problem, but if this is meant to be the Dutch city that is the seat of government, then it is Den Haag (or 's-Gravenhage if you prefer the old-fashioned name). > 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.082 2 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? I'm not sure this can be taken as an indication that wire compression is enabled or not. In Firebird 3, to determine this you can check the isc_database_info item isc_info_firebird_version; which is exposed in Firebird ado.net on FbConnection.ServerVersion. For example, when compression is not enabled, it will return: WI-V3.0.4.33054 Firebird 3.0/tcp (Ramona)/P13 When it is enabled, it will return: WI-V3.0.4.33054 Firebird 3.0/tcp (Ramona)/P13:Z (Z for zlib) Mark -- Mark Rotteveel
