Subject | Improve remote query speed on Windows Server 2012 VPS |
---|---|
Author | Mr. John |
Post date | 2017-04-14T06:22:41Z |
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