| Subject | Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS |
|---|---|
| Author | Mr. John |
| Post date | 2017-04-14T17:48:41Z |
hi
Min=37ms Max=37ms Avg=37ms
thanks
From: "'Leyne, Sean' Sean@... [firebird-support]" <firebird-support@yahoogroups.com>
To: "firebird-support@yahoogroups.com" <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?