hi Min=37ms Max=37ms Avg=37ms
<SL> Does mean that but only selecting specific columns, your SQL executed faster? <SL> Also, are using v2.5+ FBClient library on remote client? thanks ________________________________ From: "'Leyne, Sean' s...@broadviewsoftware.com<mailto:s...@broadviewsoftware.com> [firebird-support]" <firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com>> To: "firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com>" <firebird-support@yahoogroups.com<mailto:firebird-support@yahoogroups.com>> Sent: Friday, April 14, 2017 6:20 PM Subject: RE: [firebird-support] Improve remote query speed on Windows Server 2012 VPS > 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? SELECT the columns that you actually need. SELECT * is fine for debugging, but IMO a slackers approach for production code. Sean P.S. What is the latency/PING time of your connection to the remote server?
