| Subject | Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS |
|---|---|
| Author | Alexey Kovyazin |
| Post date | 2017-04-14T20:01:10Z |
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