Subject Improve remote query speed on Windows Server 2012 VPS
Author Mr. John
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