| Subject | Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS |
|---|---|
| Author | Mr. John |
| Post date | 2017-04-14T20:05:49Z |
I've done tests with fb3 (only by flamerobin) but the same results as 2.5
From: "Alexey Kovyazin ak@... [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
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
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 VPSFrom tests,remote access database works slow,a simple query on a small table with about 500 records
select * from MYTABLE where id=200
takesTotal 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 remote speed?Thanks