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-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]
      • Re: [... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
        • [... kragh.tho...@yahoo.com [firebird-support]
          • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
        • R... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
          • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
            • ... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
              • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]

Reply via email to