|Subject||RE: [firebird-support] Improve remote query speed on Windows Server 2012 VPS|
> select * from MYTABLE where id=200SELECT the columns that you actually need.
> 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 * is fine for debugging, but IMO a slackers approach for production code.
P.S. What is the latency/PING time of your connection to the remote server?