;0
thanks
From: "Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]"
<firebird-support@yahoogroups.com>
To: firebird-support@yahoogroups.com
Sent: Friday, April 14, 2017 11:22 PM
Subject: Re: [firebird-support] Improve remote query speed on Windows
4, 2017 10:08 PM
Subject: Re: [firebird-support] Improve remote query speed on Windows Server
2012 VPS
To improve speed on a Windows based system use the RDP protocol to Remote
Desktop connection on the server. The Server will run the query and your speed
will be greatly enhanced. You have
14.04.2017 22:01, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> this is just firebird specific?
No, Oracle is the same.
--
WBR, SD.
lexey Kovyazin a...@ib-aid.com [firebird-support]"
> <firebird-support@yahoogroups.com>
> To: firebird-support@yahoogroups.com
> Sent: Friday, April 14, 2017 11:01 PM
> Subject: Re: [firebird-support] Improve remote query speed on Windows
> Server 2012 VPS
>
I think it depends on how you create and maintain connection with FB
--
Regards,
Michał Kurczabiński
support] Improve remote query speed on Windows Server
2012 VPS
Hi,
Migrate to Firebird 3 - it has protocol improvements for high latency networks.
With 2.5 you will never reach such good results as with FB3.
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
Hi. I'm
this is just firebird specific?
From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]"
<firebird-support@yahoogroups.com>
To: firebird-support@yahoogroups.com
Sent: Friday, April 14, 2017 10:54 PM
Subject: Re: [firebird-support] Improve remote query speed o
Hi,
Migrate to Firebird 3 - it has protocol improvements for high latency
networks.
With 2.5 you will never reach such good results as with FB3.
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
Hi.
I'm testing Firebird 2.5 x64 on Windows Server 2012 R2 VPS
From tests,remote access
14.04.2017 21:40, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> indeed is faster
Working with Firebird via high latency network require very careful
application design
and development. You, literally, must count every round trip to server and
every received
byte.
--
WBR,
PM
Subject: Re: [firebird-support] Improve remote query speed on Windows Server
2012 VPS
With isql is same issue?
I have with flamerobin on remote machine big delay, while with eg. orbada
database manager there is no additional delay.
--
Regards,
Michał Kurczabiński #yiv247982165
indeed is faster
From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]"
<firebird-support@yahoogroups.com>
To: firebird-support@yahoogroups.com
Sent: Friday, April 14, 2017 10:29 PM
Subject: Re: [firebird-support] Improve remote query speed on Windows
With isql is same issue?
I have with flamerobin on remote machine big delay, while with eg. orbada
database manager there is no additional delay.
--
Regards,
Michał Kurczabiński
14.04.2017 21:27, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I don't think
Just try.
--
WBR, SD.
++
Visit
firebird-support] Improve remote query speed on Windows Server
2012 VPS
14.04.2017 21:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> select count(*) remote is fast
> Total execution time: 0.386s
If you use isql instead of Flame Robin/IBExpert does it make any diffe
14.04.2017 21:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> select count(*) remote is fast
> Total execution time: 0.386s
If you use isql instead of Flame Robin/IBExpert does it make any difference?
--
WBR, SD.
firebird-support@yahoogroups.com
Sent: Friday, April 14, 2017 10:08 PM
Subject: Re: [firebird-support] Improve remote query speed on Windows Server
2012 VPS
14.04.2017 20:50, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> on another table,same db, with 7 records and 12 columns takes * 2
no blob field.thanks
From: "Thomas Kragh t...@uvdata.dk [firebird-support]"
<firebird-support@yahoogroups.com>
To: firebird-support@yahoogroups.com
Sent: Friday, April 14, 2017 10:06 PM
Subject: RE: [firebird-support] Improve remote query speed on Windows Server
2012
14.04.2017 20:50, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> on another table,same db, with 7 records and 12 columns takes * 2.362s*
Is result the same if query is executed from server or if count(*) is
requested instead
of whole data set?
--
WBR, SD.
t;
To: Firebird-support <firebird-support@yahoogroups.com>
Sent: Friday, April 14, 2017 12:22 AM
Subject: [firebird-support] Improve remote query speed on Windows Server 2012
VPS
Hi.I'm testing Firebird 2.5 x64 on Windows Server 2012 R2 VPSFrom
tests,remote access database wor
Does MYTABLE contain any blob columns with data that might be fetched?
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Friday, April 14, 2017 17:20
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Improve remote query speed on Windows
ent: Friday, April 14, 2017 9:29 PM
Subject: Re: [firebird-support] Improve remote query speed on Windows Server
2012 VPS
hi.I put only 2 columns but seems the same result
From: "'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]"
<firebird-support@yahoogroup
il 14, 2017 9:13 PM
Subject: RE: [firebird-support] Improve remote query speed on Windows Server
2012 VPS
hi Min=37ms Max=37ms Avg=37ms Does mean that but only
selecting specific columns, your SQL executed faster? Also, are using
v2.5+ FBClient library on remote client?
com>>
Sent: Friday, April 14, 2017 6:20 PM
Subject: RE: [firebird-support] Improve remote query speed on Windows Server
2012 VPS
> select * from MYTABLE where id=200
>
> takes
>Total execution time: 5.388s
>PLAN (MYTABLE INDEX (PK_MYTABLE))
>
> the same
Subject: RE: [firebird-support] Improve remote query speed on Windows Server
2012 VPS
> select * from MYTABLE where id=200
>
> takes
> Total execution time: 5.388s
> PLAN (MYTABLE INDEX (PK_MYTABLE))
>
> the same query executed local on the server(same db,server
> select * from MYTABLE where id=200
>
> takes
> Total execution time: 5.388s
> PLAN (MYTABLE INDEX (PK_MYTABLE))
>
> the same query executed local on the server(same db,server) takes 0.065s
>
> queries are done with Flamerobin,from IBExpert the same results
>
> How can I improve
<firebird-support@yahoogroups.com>
To: firebird-support@yahoogroups.com
Sent: Friday, April 14, 2017 2:30 PM
Subject: Re: [firebird-support] Improve remote query speed on Windows Server
2012 VPS
14.04.2017 8:22, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> How can I i
14.04.2017 8:22, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> How can I improve remote speed?
Increase value of "TcpRemoteBufferSize" parameter in firebird.conf to max.
--
WBR, SD.
Hi.I'm testing Firebird 2.5 x64 on Windows Server 2012 R2 VPSFrom tests,remote
access database works slow,a simple query on a small table with about 500
records
select * from MYTABLE where id=200
takes Total execution time: 5.388s
PLAN (MYTABLE INDEX (PK_MYTABLE))
the same query
28 matches
Mail list logo