>> 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 =
>>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
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
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
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
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
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
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
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.
++
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.
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.
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,
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 ...
--
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,
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
You can do this without window function also in FB<3, but less efective. Do
simple 2 subselects in your select.
Regards,
Karol Bieniaszewski
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
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
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
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
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
>
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
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
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
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'
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
27 matches
Mail list logo