no blob field.thanks
From: "Thomas Kragh [email protected] [firebird-support]"
<[email protected]>
To: [email protected]
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: [email protected] [mailto:[email protected]]
Sent: Friday, April 14, 2017 17:20
To: [email protected]
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
A part of KMD
Stigsborgvej 60, 9400 Nørresundby
[email protected] 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.
#yiv9686157046 #yiv9686157046 -- #yiv9686157046ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9686157046
#yiv9686157046ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9686157046
#yiv9686157046ygrp-mkp #yiv9686157046hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9686157046 #yiv9686157046ygrp-mkp #yiv9686157046ads
{margin-bottom:10px;}#yiv9686157046 #yiv9686157046ygrp-mkp .yiv9686157046ad
{padding:0 0;}#yiv9686157046 #yiv9686157046ygrp-mkp .yiv9686157046ad p
{margin:0;}#yiv9686157046 #yiv9686157046ygrp-mkp .yiv9686157046ad a
{color:#0000ff;text-decoration:none;}#yiv9686157046 #yiv9686157046ygrp-sponsor
#yiv9686157046ygrp-lc {font-family:Arial;}#yiv9686157046
#yiv9686157046ygrp-sponsor #yiv9686157046ygrp-lc #yiv9686157046hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9686157046
#yiv9686157046ygrp-sponsor #yiv9686157046ygrp-lc .yiv9686157046ad
{margin-bottom:10px;padding:0 0;}#yiv9686157046 #yiv9686157046actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9686157046
#yiv9686157046activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9686157046
#yiv9686157046activity span {font-weight:700;}#yiv9686157046
#yiv9686157046activity span:first-child
{text-transform:uppercase;}#yiv9686157046 #yiv9686157046activity span a
{color:#5085b6;text-decoration:none;}#yiv9686157046 #yiv9686157046activity span
span {color:#ff7900;}#yiv9686157046 #yiv9686157046activity span
.yiv9686157046underline {text-decoration:underline;}#yiv9686157046
.yiv9686157046attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9686157046 .yiv9686157046attach div a
{text-decoration:none;}#yiv9686157046 .yiv9686157046attach img
{border:none;padding-right:5px;}#yiv9686157046 .yiv9686157046attach label
{display:block;margin-bottom:5px;}#yiv9686157046 .yiv9686157046attach label a
{text-decoration:none;}#yiv9686157046 blockquote {margin:0 0 0
4px;}#yiv9686157046 .yiv9686157046bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9686157046
.yiv9686157046bold a {text-decoration:none;}#yiv9686157046 dd.yiv9686157046last
p a {font-family:Verdana;font-weight:700;}#yiv9686157046 dd.yiv9686157046last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9686157046
dd.yiv9686157046last p span.yiv9686157046yshortcuts
{margin-right:0;}#yiv9686157046 div.yiv9686157046attach-table div div a
{text-decoration:none;}#yiv9686157046 div.yiv9686157046attach-table
{width:400px;}#yiv9686157046 div.yiv9686157046file-title a, #yiv9686157046
div.yiv9686157046file-title a:active, #yiv9686157046
div.yiv9686157046file-title a:hover, #yiv9686157046 div.yiv9686157046file-title
a:visited {text-decoration:none;}#yiv9686157046 div.yiv9686157046photo-title a,
#yiv9686157046 div.yiv9686157046photo-title a:active, #yiv9686157046
div.yiv9686157046photo-title a:hover, #yiv9686157046
div.yiv9686157046photo-title a:visited {text-decoration:none;}#yiv9686157046
div#yiv9686157046ygrp-mlmsg #yiv9686157046ygrp-msg p a
span.yiv9686157046yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9686157046
.yiv9686157046green {color:#628c2a;}#yiv9686157046 .yiv9686157046MsoNormal
{margin:0 0 0 0;}#yiv9686157046 o {font-size:0;}#yiv9686157046
#yiv9686157046photos div {float:left;width:72px;}#yiv9686157046
#yiv9686157046photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9686157046
#yiv9686157046photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9686157046
#yiv9686157046reco-category {font-size:77%;}#yiv9686157046
#yiv9686157046reco-desc {font-size:77%;}#yiv9686157046 .yiv9686157046replbq
{margin:4px;}#yiv9686157046 #yiv9686157046ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9686157046 #yiv9686157046ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9686157046
#yiv9686157046ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9686157046
#yiv9686157046ygrp-mlmsg select, #yiv9686157046 input, #yiv9686157046 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9686157046
#yiv9686157046ygrp-mlmsg pre, #yiv9686157046 code {font:115%
monospace;}#yiv9686157046 #yiv9686157046ygrp-mlmsg *
{line-height:1.22em;}#yiv9686157046 #yiv9686157046ygrp-mlmsg #yiv9686157046logo
{padding-bottom:10px;}#yiv9686157046 #yiv9686157046ygrp-msg p a
{font-family:Verdana;}#yiv9686157046 #yiv9686157046ygrp-msg
p#yiv9686157046attach-count span {color:#1E66AE;font-weight:700;}#yiv9686157046
#yiv9686157046ygrp-reco #yiv9686157046reco-head
{color:#ff7900;font-weight:700;}#yiv9686157046 #yiv9686157046ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9686157046 #yiv9686157046ygrp-sponsor
#yiv9686157046ov li a {font-size:130%;text-decoration:none;}#yiv9686157046
#yiv9686157046ygrp-sponsor #yiv9686157046ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9686157046
#yiv9686157046ygrp-sponsor #yiv9686157046ov ul {margin:0;padding:0 0 0
8px;}#yiv9686157046 #yiv9686157046ygrp-text
{font-family:Georgia;}#yiv9686157046 #yiv9686157046ygrp-text p {margin:0 0 1em
0;}#yiv9686157046 #yiv9686157046ygrp-text tt {font-size:120%;}#yiv9686157046
#yiv9686157046ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9686157046
