Subject Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS
Author Mr. John
Post date 2017-04-14T19:10:21Z
no blob field.thanks



From: "Thomas Kragh tk@... [firebird-support]" <firebird-support@yahoogroups.com>
To: firebird-support@yahoogroups.com
Sent: Friday, April 14, 2017 10:06 PM
Subject: RE: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

 
Does MYTABLE contain any blob columns with data that might be fetched?
 
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Friday, April 14, 2017 17:20
To: firebird-support@yahoogroups.com
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?

Venlig hilsen

Thomas Kragh, Udvikler

uvdata logo
A part of KMD 

Stigsborgvej 60, 9400 Nørresundby
E-mail tk@...  Web www.uvdata.dk
Telefon +45 72287030

Vi gør opmærksom på, at denne e-mail kan indeholde fortrolig information. Hvis du ved en fejltagelse modtager e-mailen, beder vi dig venligst informere afsender om fejlen ved at bruge svarfunktionen. Samtidig beder vi dig slette e-mailen i dit system uden at videresende eller kopiere den. Selvom e-mailen og ethvert vedhæftet bilag efter vores overbevisning er fri for virus og andre fejl, som kan påvirke computeren eller it-systemet, hvori den modtages og læses, åbnes den på modtagerens eget ansvar. Vi påtager os ikke noget ansvar for tab og skade, som er opstået i forbindelse med at modtage og bruge e-mailen.
Please note that this message may contain confidential information. If you have received this message by mistake, please inform the sender of the mistake by sending a reply, then delete the message from your system without making, distributing or retaining any copies of it. Although we believe that the message and any attachments are free from viruses and other errors that might affect the computer or it-system where it is received and read, the recipient opens the message at his or her own risk. We assume no responsibility for any loss or damage arising from the receipt or use of this message.