Subject Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS
Author Mr. John
hi
when I've installed the server it was checked the option to copy client library to system folder


in FB 3
select * from MYTABLE where id=200 
takes 6 seconds


select rdb$get_context('SYSTEM','ENGINE_VERSION') from rdb$database

result: 3.0.2

for  'select * from Mon$Attachments' iused flamerobin to export result as csv:

MON$ATTACHMENT_ID;MON$SERVER_PID;MON$STATE;MON$ATTACHMENT_NAME;MON$USER;MON$ROLE;MON$REMOTE_PROTOCOL;MON$REMOTE_ADDRESS;MON$REMOTE_PID;MON$CHARACTER_SET_ID;MON$TIMESTAMP;MON$GARBAGE_COLLECTION;MON$REMOTE_PROCESS;MON$STAT_ID;MON$CLIENT_VERSION;MON$REMOTE_VERSION;MON$REMOTE_HOST;MON$REMOTE_OS_USER;MON$AUTH_METHOD;MON$SYSTEM_FLAG
39;1788;0;C:\DATA\MYDB.FDB;Cache Writer                   ;NULL;NULL;NULL;NULL;0;15.04.2017, 04:06:34.502;1;NULL;22;NULL;NULL;NULL;NULL;NULL;1
40;1788;0;C:\DATA\MYDB.FDB;Garbage Collector              ;NULL;NULL;NULL;NULL;0;15.04.2017, 04:06:34.502;1;NULL;23;NULL;NULL;NULL;NULL;NULL;1
41;1788;1;C:\DATA\MYDB.FDB;SYSDBA                         ;NONE                           ;TCPv4;5.14.8.63/2277;5680;0;15.04.2017, 04:06:34.399;1;C:\Program Files\FlameRobin (x64)\flamerobin.exe;24;WI-V3.0.2.32703 Firebird 3.0;P15;desktop-udep1s6;user;Srp;0


thanks



From: "Slavomir Skopalik skopalik@... [firebird-support]" <firebird-support@yahoogroups.com>
To: firebird-support@yahoogroups.com
Sent: Friday, April 14, 2017 11:22 PM
Subject: Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

 
And did you update client library as well?

please run this sql in isql and post here result:

select * from Mon$Attachments

and for sure

select rdb$get_context('SYSTEM','ENGINE_VERSION') from rdb$database

Slavek

Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
----------------------------------------------------------
Address:
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
----------------------------------------------------------
Mobile: +420 724 207 851
icq:199 118 333
skype:skopaliks
e-mail:skopalik@...
http://www.elektlabs.cz

On 14.4.2017 22:05, 'Mr. John' mr_johnmr@... [firebird-support] wrote:
> I've done tests with fb3 (only by flamerobin) but the same results as 2.5
>
> From: "Alexey Kovyazin ak@... [firebird-support]" <firebird-support@yahoogroups.com>
> To: firebird-support@yahoogroups.com
> Sent: Friday, April 14, 2017 11:01 PM
> Subject: Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS
>
> Hi,
>
> Migrate to Firebird 3 - it has protocol improvements for high latency networks.
> With 2.5 you will never reach such good results as with FB3.
>
> Regards,
> Alexey Kovyazin
> IBSurgeon www.ib-aid.com
>
>
>
>
>
>
> Hi. I'm testing Firebird 2.5 x64 on Windows Server 2012 R2 VPS From tests,remote access database works slow,a simple query on a small table with about 500 records
> 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? Thanks
>
>
> #yiv7322016214 #yiv7322016214 -- #yiv7322016214ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7322016214 #yiv7322016214ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7322016214 #yiv7322016214ygrp-mkp #yiv7322016214hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7322016214 #yiv7322016214ygrp-mkp #yiv7322016214ads {margin-bottom:10px;}#yiv7322016214 #yiv7322016214ygrp-mkp .yiv7322016214ad {padding:0 0;}#yiv7322016214 #yiv7322016214ygrp-mkp .yiv7322016214ad p {margin:0;}#yiv7322016214 #yiv7322016214ygrp-mkp .yiv7322016214ad a {color:#0000ff;text-decoration:none;}#yiv7322016214 #yiv7322016214ygrp-sponsor #yiv7322016214ygrp-lc {font-family:Arial;}#yiv7322016214 #yiv7322016214ygrp-sponsor #yiv7322016214ygrp-lc #yiv7322016214hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7322016214 #yiv7322016214ygrp-sponsor #yiv7322016214ygrp-lc .yiv7322016214ad {margin-bottom:10px;padding:0 0;}#yiv7322016214 #yiv7322016214actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7322016214 #yiv7322016214activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7322016214 #yiv7322016214activity span {font-weight:700;}#yiv7322016214 #yiv7322016214activity span:first-child {text-transform:uppercase;}#yiv7322016214 #yiv7322016214activity span a {color:#5085b6;text-decoration:none;}#yiv7322016214 #yiv7322016214activity span span {color:#ff7900;}#yiv7322016214 #yiv7322016214activity span .yiv7322016214underline {text-decoration:underline;}#yiv7322016214 .yiv7322016214attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7322016214 .yiv7322016214attach div a {text-decoration:none;}#yiv7322016214 .yiv7322016214attach img {border:none;padding-right:5px;}#yiv7322016214 .yiv7322016214attach label {display:block;margin-bottom:5px;}#yiv7322016214 .yiv7322016214attach label a {text-decoration:none;}#yiv7322016214 blockquote {margin:0 0 0 4px;}#yiv7322016214 .yiv7322016214bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7322016214 .yiv7322016214bold a {text-decoration:none;}#yiv7322016214 dd.yiv7322016214last p a {font-family:Verdana;font-weight:700;}#yiv7322016214 dd.yiv7322016214last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7322016214 dd.yiv7322016214last p span.yiv7322016214yshortcuts {margin-right:0;}#yiv7322016214 div.yiv7322016214attach-table div div a {text-decoration:none;}#yiv7322016214 div.yiv7322016214attach-table {width:400px;}#yiv7322016214 div.yiv7322016214file-title a, #yiv7322016214 div.yiv7322016214file-title a:active, #yiv7322016214 div.yiv7322016214file-title a:hover, #yiv7322016214 div.yiv7322016214file-title a:visited {text-decoration:none;}#yiv7322016214 div.yiv7322016214photo-title a, #yiv7322016214 div.yiv7322016214photo-title a:active, #yiv7322016214 div.yiv7322016214photo-title a:hover, #yiv7322016214 div.yiv7322016214photo-title a:visited {text-decoration:none;}#yiv7322016214 div#yiv7322016214ygrp-mlmsg #yiv7322016214ygrp-msg p a span.yiv7322016214yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7322016214 .yiv7322016214green {color:#628c2a;}#yiv7322016214 .yiv7322016214MsoNormal {margin:0 0 0 0;}#yiv7322016214 o {font-size:0;}#yiv7322016214 #yiv7322016214photos div {float:left;width:72px;}#yiv7322016214 #yiv7322016214photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7322016214 #yiv7322016214photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7322016214 #yiv7322016214reco-category {font-size:77%;}#yiv7322016214 #yiv7322016214reco-desc {font-size:77%;}#yiv7322016214 .yiv7322016214replbq {margin:4px;}#yiv7322016214 #yiv7322016214ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7322016214 #yiv7322016214ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7322016214 #yiv7322016214ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7322016214 #yiv7322016214ygrp-mlmsg select, #yiv7322016214 input, #yiv7322016214 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7322016214 #yiv7322016214ygrp-mlmsg pre, #yiv7322016214 code {font:115% monospace;}#yiv7322016214 #yiv7322016214ygrp-mlmsg * {line-height:1.22em;}#yiv7322016214 #yiv7322016214ygrp-mlmsg #yiv7322016214logo {padding-bottom:10px;}#yiv7322016214 #yiv7322016214ygrp-msg p a {font-family:Verdana;}#yiv7322016214 #yiv7322016214ygrp-msg p#yiv7322016214attach-count span {color:#1E66AE;font-weight:700;}#yiv7322016214 #yiv7322016214ygrp-reco #yiv7322016214reco-head {color:#ff7900;font-weight:700;}#yiv7322016214 #yiv7322016214ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7322016214 #yiv7322016214ygrp-sponsor #yiv7322016214ov li a {font-size:130%;text-decoration:none;}#yiv7322016214 #yiv7322016214ygrp-sponsor #yiv7322016214ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7322016214 #yiv7322016214ygrp-sponsor #yiv7322016214ov ul {margin:0;padding:0 0 0 8px;}#yiv7322016214 #yiv7322016214ygrp-text {font-family:Georgia;}#yiv7322016214 #yiv7322016214ygrp-text p {margin:0 0 1em 0;}#yiv7322016214 #yiv7322016214ygrp-text tt {font-size:120%;}#yiv7322016214 #yiv7322016214ygrp-vital ul li:last-child {border-right:none !important;}#yiv7322016214
>
>