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 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
[firebird-support] Improve remote query speed on Windows Server 2012 VPS
'Mr. John' mr_joh...@yahoo.com [firebird-support] Thu, 13 Apr 2017 23:23:09 -0700
- [firebird-supp... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
- Re: [fire... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
- Re: [... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
- RE: [fire... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]