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 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 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