Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

hiwhen I've installed the server it was checked the option to copy client 
library to system folder

in FB 3select * 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_FLAG39;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;140;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;141;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 skopa...@elektlabs.cz [firebird-support]" 

 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:skopa...@elektlabs.cz
http://www.elektlabs.cz

On 14.4.2017 22:05, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I've done tests with fb3 (only by flamerobin) but the same results as 2.5
>
> From: "Alexey Kovyazin a...@ib-aid.com [firebird-support]" 
> 
> 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:#ff;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 
> 

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

thanks for the info but now it is not an option for me since the license 
requires to pay on every month


  From: "Jack Engleman jack_engle...@yahoo.com [firebird-support]" 

 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 10:08 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
    To improve speed on a Windows based system use the RDP protocol to Remote 
Desktop connection on the server.  The Server will run the query and your speed 
will be greatly enhanced.  You have to purchase RPD licenses for you server and 
that increases the cost of implementation. I have a server that has 30 firebird 
databases running on it. I have up to 80 users  at a time on my server and all 
customers are very happy with the speed of the server.
Best Regards
Jack Engleman


  From: "'Mr. John' mr_joh...@yahoo.com [firebird-support]" 

 To: Firebird-support  
 Sent: Friday, April 14, 2017 12:22 AM
 Subject: [firebird-support] Improve remote query speed on Windows Server 2012 
VPS
  
    Hi.I'm testing Firebird 2.5 x64 on Windows Server 2012 R2 VPSFrom 
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
  

 #yiv8551892718 #yiv8551892718 -- #yiv8551892718ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8551892718 
#yiv8551892718ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8551892718 
#yiv8551892718ygrp-mkp #yiv8551892718hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv8551892718 #yiv8551892718ygrp-mkp #yiv8551892718ads 
{margin-bottom:10px;}#yiv8551892718 #yiv8551892718ygrp-mkp .yiv8551892718ad 
{padding:0 0;}#yiv8551892718 #yiv8551892718ygrp-mkp .yiv8551892718ad p 
{margin:0;}#yiv8551892718 #yiv8551892718ygrp-mkp .yiv8551892718ad a 
{color:#ff;text-decoration:none;}#yiv8551892718 #yiv8551892718ygrp-sponsor 
#yiv8551892718ygrp-lc {font-family:Arial;}#yiv8551892718 
#yiv8551892718ygrp-sponsor #yiv8551892718ygrp-lc #yiv8551892718hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8551892718 
#yiv8551892718ygrp-sponsor #yiv8551892718ygrp-lc .yiv8551892718ad 
{margin-bottom:10px;padding:0 0;}#yiv8551892718 #yiv8551892718actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8551892718 
#yiv8551892718activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8551892718
 #yiv8551892718activity span {font-weight:700;}#yiv8551892718 
#yiv8551892718activity span:first-child 
{text-transform:uppercase;}#yiv8551892718 #yiv8551892718activity span a 
{color:#5085b6;text-decoration:none;}#yiv8551892718 #yiv8551892718activity span 
span {color:#ff7900;}#yiv8551892718 #yiv8551892718activity span 
.yiv8551892718underline {text-decoration:underline;}#yiv8551892718 
.yiv8551892718attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv8551892718 .yiv8551892718attach div a 
{text-decoration:none;}#yiv8551892718 .yiv8551892718attach img 
{border:none;padding-right:5px;}#yiv8551892718 .yiv8551892718attach label 
{display:block;margin-bottom:5px;}#yiv8551892718 .yiv8551892718attach label a 
{text-decoration:none;}#yiv8551892718 blockquote {margin:0 0 0 
4px;}#yiv8551892718 .yiv8551892718bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8551892718 
.yiv8551892718bold a {text-decoration:none;}#yiv8551892718 dd.yiv8551892718last 
p a {font-family:Verdana;font-weight:700;}#yiv8551892718 dd.yiv8551892718last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8551892718 
dd.yiv8551892718last p span.yiv8551892718yshortcuts 
{margin-right:0;}#yiv8551892718 div.yiv8551892718attach-table div div a 
{text-decoration:none;}#yiv8551892718 div.yiv8551892718attach-table 
{width:400px;}#yiv8551892718 div.yiv8551892718file-title a, #yiv8551892718 
div.yiv8551892718file-title a:active, #yiv8551892718 
div.yiv8551892718file-title a:hover, #yiv8551892718 div.yiv8551892718file-title 
a:visited {text-decoration:none;}#yiv8551892718 div.yiv8551892718photo-title a, 
#yiv8551892718 div.yiv8551892718photo-title a:active, #yiv8551892718 
div.yiv8551892718photo-title a:hover, #yiv8551892718 
div.yiv8551892718photo-title a:visited {text-decoration:none;}#yiv8551892718 
div#yiv8551892718ygrp-mlmsg #yiv8551892718ygrp-msg p a 
span.yiv8551892718yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8551892718 
.yiv8551892718green {color:#628c2a;}#yiv8551892718 .yiv8551892718MsoNormal 
{margin:0 0 0 0;}#yiv8551892718 o 

[firebird-support] Entity Relationship Diagram

['Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]]

Hello everyone

Excuse me if it is an off-topic.

Do you know some good program for Entity Relationship Diagram using
Firebird databases?

I mean, having a Firebird database get its ERD

Mister Google can answer that question but is not the same as comments of
people who are using such programs.

Greetings.

Walter.

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

14.04.2017 22:01, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> this is just firebird specific?

   No, Oracle is the same.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

[Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]]

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:skopa...@elektlabs.cz
http://www.elektlabs.cz

On 14.4.2017 22:05, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I've done tests with fb3 (only by flamerobin)  but the same results as 2.5
>
>From: "Alexey Kovyazin a...@ib-aid.com [firebird-support]" 
> 
>   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:#ff;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 

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

[Michal Kurczabinski michk...@gmail.com [firebird-support]]

I think it depends on how you create and maintain connection with FB

-- 
Regards,
Michał Kurczabiński

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

I've done tests with fb3 (only by flamerobin)  but the same results as 2.5

  From: "Alexey Kovyazin a...@ib-aid.com [firebird-support]" 

 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:#ff;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 
#66;height:62px;overflow:hidden;width:62px;}#yiv7322016214 
#yiv7322016214photos div label 
{color:#66;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 

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

this is just firebird specific?

  From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 

 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 10:54 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
14.04.2017 21:40, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> indeed is faster

  Working with Firebird via high latency network require very careful 
application design 
and development. You, literally, must count every round trip to server and 
every received 
byte.


-- 
  WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links





   

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

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

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

14.04.2017 21:40, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> indeed is faster

   Working with Firebird via high latency network require very careful 
application design 
and development. You, literally, must count every round trip to server and 
every received 
byte.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

indeed with orbada    247ms instead of 5-6 seconds...also ibeExpert is slow and 
my app too

  From: "Michal Kurczabinski michk...@gmail.com [firebird-support]" 

 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 10:33 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
    With isql is same issue?

I have with flamerobin on remote machine big delay, while with eg. orbada 
database manager there is no additional delay.


-- 
Regards, 
Michał Kurczabiński  #yiv2479821658 #yiv2479821658 -- #yiv2479821658ygrp-mkp 
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 
10px;}#yiv2479821658 #yiv2479821658ygrp-mkp hr {border:1px solid 
#d8d8d8;}#yiv2479821658 #yiv2479821658ygrp-mkp #yiv2479821658hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv2479821658 #yiv2479821658ygrp-mkp #yiv2479821658ads 
{margin-bottom:10px;}#yiv2479821658 #yiv2479821658ygrp-mkp .yiv2479821658ad 
{padding:0 0;}#yiv2479821658 #yiv2479821658ygrp-mkp .yiv2479821658ad p 
{margin:0;}#yiv2479821658 #yiv2479821658ygrp-mkp .yiv2479821658ad a 
{color:#ff;text-decoration:none;}#yiv2479821658 #yiv2479821658ygrp-sponsor 
#yiv2479821658ygrp-lc {font-family:Arial;}#yiv2479821658 
#yiv2479821658ygrp-sponsor #yiv2479821658ygrp-lc #yiv2479821658hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2479821658 
#yiv2479821658ygrp-sponsor #yiv2479821658ygrp-lc .yiv2479821658ad 
{margin-bottom:10px;padding:0 0;}#yiv2479821658 #yiv2479821658actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2479821658 
#yiv2479821658activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2479821658
 #yiv2479821658activity span {font-weight:700;}#yiv2479821658 
#yiv2479821658activity span:first-child 
{text-transform:uppercase;}#yiv2479821658 #yiv2479821658activity span a 
{color:#5085b6;text-decoration:none;}#yiv2479821658 #yiv2479821658activity span 
span {color:#ff7900;}#yiv2479821658 #yiv2479821658activity span 
.yiv2479821658underline {text-decoration:underline;}#yiv2479821658 
.yiv2479821658attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv2479821658 .yiv2479821658attach div a 
{text-decoration:none;}#yiv2479821658 .yiv2479821658attach img 
{border:none;padding-right:5px;}#yiv2479821658 .yiv2479821658attach label 
{display:block;margin-bottom:5px;}#yiv2479821658 .yiv2479821658attach label a 
{text-decoration:none;}#yiv2479821658 blockquote {margin:0 0 0 
4px;}#yiv2479821658 .yiv2479821658bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2479821658 
.yiv2479821658bold a {text-decoration:none;}#yiv2479821658 dd.yiv2479821658last 
p a {font-family:Verdana;font-weight:700;}#yiv2479821658 dd.yiv2479821658last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2479821658 
dd.yiv2479821658last p span.yiv2479821658yshortcuts 
{margin-right:0;}#yiv2479821658 div.yiv2479821658attach-table div div a 
{text-decoration:none;}#yiv2479821658 div.yiv2479821658attach-table 
{width:400px;}#yiv2479821658 div.yiv2479821658file-title a, #yiv2479821658 
div.yiv2479821658file-title a:active, #yiv2479821658 
div.yiv2479821658file-title a:hover, #yiv2479821658 div.yiv2479821658file-title 
a:visited {text-decoration:none;}#yiv2479821658 div.yiv2479821658photo-title a, 
#yiv2479821658 div.yiv2479821658photo-title a:active, #yiv2479821658 
div.yiv2479821658photo-title a:hover, #yiv2479821658 
div.yiv2479821658photo-title a:visited {text-decoration:none;}#yiv2479821658 
div#yiv2479821658ygrp-mlmsg #yiv2479821658ygrp-msg p a 
span.yiv2479821658yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2479821658 
.yiv2479821658green {color:#628c2a;}#yiv2479821658 .yiv2479821658MsoNormal 
{margin:0 0 0 0;}#yiv2479821658 o {font-size:0;}#yiv2479821658 
#yiv2479821658photos div {float:left;width:72px;}#yiv2479821658 
#yiv2479821658photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv2479821658 
#yiv2479821658photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2479821658
 #yiv2479821658reco-category {font-size:77%;}#yiv2479821658 
#yiv2479821658reco-desc {font-size:77%;}#yiv2479821658 .yiv2479821658replbq 
{margin:4px;}#yiv2479821658 #yiv2479821658ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv2479821658 #yiv2479821658ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2479821658 
#yiv2479821658ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2479821658 
#yiv2479821658ygrp-mlmsg select, #yiv2479821658 input, #yiv2479821658 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2479821658 
#yiv2479821658ygrp-mlmsg pre, #yiv2479821658 code {font:115% 
monospace;}#yiv2479821658 #yiv2479821658ygrp-mlmsg * 

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

indeed is faster

  From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 

 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 10:29 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
14.04.2017 21:27, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I don't think

  Just try.


-- 
  WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links





   

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

[Michal Kurczabinski michk...@gmail.com [firebird-support]]

With isql is same issue?

I have with flamerobin on remote machine big delay, while with eg. orbada
database manager there is no additional delay.


-- 
Regards,
Michał Kurczabiński

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

14.04.2017 21:27, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> I don't think

   Just try.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

I don't think,I have an application that runs slow too on that db/connection

  From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 

 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 10:26 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
14.04.2017 21:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> select count(*)  remote  is fast
> Total execution time: 0.386s

  If you use isql instead of Flame Robin/IBExpert does it make any difference?


-- 
  WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links





   

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

14.04.2017 21:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> select count(*)  remote   is fast
> Total execution time: 0.386s

   If you use isql instead of Flame Robin/IBExpert does it make any difference?


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

select count(*)  remote   is fast Total execution time: 0.386s

executed on the server  querys are fast  select * from MYTABLE where id=200   
takes  0.065s


  From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 

 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 10:08 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
14.04.2017 20:50, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> on another table,same db, with 7 records and  12 columns takes * 2.362s*

  Is result the same if query is executed from server or if count(*) is 
requested instead 
of whole data set?


-- 
  WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links





   

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

no blob field.thanks


  From: "Thomas Kragh t...@uvdata.dk [firebird-support]" 

 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


A part of KMD 

Stigsborgvej 60, 9400 Nørresundby
e-mai...@uvdata.dk  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:#ff;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 

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

14.04.2017 20:50, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> on another table,same db, with 7 records and  12 columns takes * 2.362s*

   Is result the same if query is executed from server or if count(*) is 
requested instead 
of whole data set?


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

[Jack Engleman jack_engle...@yahoo.com [firebird-support]]

To improve speed on a Windows based system use the RDP protocol to Remote 
Desktop connection on the server.  The Server will run the query and your speed 
will be greatly enhanced.  You have to purchase RPD licenses for you server and 
that increases the cost of implementation. I have a server that has 30 firebird 
databases running on it. I have up to 80 users  at a time on my server and all 
customers are very happy with the speed of the server.
Best Regards
Jack Engleman




  From: "'Mr. John' mr_joh...@yahoo.com [firebird-support]" 

 To: Firebird-support 
 Sent: Friday, April 14, 2017 12:22 AM
 Subject: [firebird-support] Improve remote query speed on Windows Server 2012 
VPS

    Hi.I'm testing Firebird 2.5 x64 on Windows Server 2012 R2 VPSFrom 
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
  #yiv1344503004 #yiv1344503004 -- #yiv1344503004ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1344503004 
#yiv1344503004ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1344503004 
#yiv1344503004ygrp-mkp #yiv1344503004hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv1344503004 #yiv1344503004ygrp-mkp #yiv1344503004ads 
{margin-bottom:10px;}#yiv1344503004 #yiv1344503004ygrp-mkp .yiv1344503004ad 
{padding:0 0;}#yiv1344503004 #yiv1344503004ygrp-mkp .yiv1344503004ad p 
{margin:0;}#yiv1344503004 #yiv1344503004ygrp-mkp .yiv1344503004ad a 
{color:#ff;text-decoration:none;}#yiv1344503004 #yiv1344503004ygrp-sponsor 
#yiv1344503004ygrp-lc {font-family:Arial;}#yiv1344503004 
#yiv1344503004ygrp-sponsor #yiv1344503004ygrp-lc #yiv1344503004hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1344503004 
#yiv1344503004ygrp-sponsor #yiv1344503004ygrp-lc .yiv1344503004ad 
{margin-bottom:10px;padding:0 0;}#yiv1344503004 #yiv1344503004actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1344503004 
#yiv1344503004activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1344503004
 #yiv1344503004activity span {font-weight:700;}#yiv1344503004 
#yiv1344503004activity span:first-child 
{text-transform:uppercase;}#yiv1344503004 #yiv1344503004activity span a 
{color:#5085b6;text-decoration:none;}#yiv1344503004 #yiv1344503004activity span 
span {color:#ff7900;}#yiv1344503004 #yiv1344503004activity span 
.yiv1344503004underline {text-decoration:underline;}#yiv1344503004 
.yiv1344503004attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv1344503004 .yiv1344503004attach div a 
{text-decoration:none;}#yiv1344503004 .yiv1344503004attach img 
{border:none;padding-right:5px;}#yiv1344503004 .yiv1344503004attach label 
{display:block;margin-bottom:5px;}#yiv1344503004 .yiv1344503004attach label a 
{text-decoration:none;}#yiv1344503004 blockquote {margin:0 0 0 
4px;}#yiv1344503004 .yiv1344503004bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1344503004 
.yiv1344503004bold a {text-decoration:none;}#yiv1344503004 dd.yiv1344503004last 
p a {font-family:Verdana;font-weight:700;}#yiv1344503004 dd.yiv1344503004last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1344503004 
dd.yiv1344503004last p span.yiv1344503004yshortcuts 
{margin-right:0;}#yiv1344503004 div.yiv1344503004attach-table div div a 
{text-decoration:none;}#yiv1344503004 div.yiv1344503004attach-table 
{width:400px;}#yiv1344503004 div.yiv1344503004file-title a, #yiv1344503004 
div.yiv1344503004file-title a:active, #yiv1344503004 
div.yiv1344503004file-title a:hover, #yiv1344503004 div.yiv1344503004file-title 
a:visited {text-decoration:none;}#yiv1344503004 div.yiv1344503004photo-title a, 
#yiv1344503004 div.yiv1344503004photo-title a:active, #yiv1344503004 
div.yiv1344503004photo-title a:hover, #yiv1344503004 
div.yiv1344503004photo-title a:visited {text-decoration:none;}#yiv1344503004 
div#yiv1344503004ygrp-mlmsg #yiv1344503004ygrp-msg p a 
span.yiv1344503004yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1344503004 
.yiv1344503004green {color:#628c2a;}#yiv1344503004 .yiv1344503004MsoNormal 
{margin:0 0 0 0;}#yiv1344503004 o {font-size:0;}#yiv1344503004 
#yiv1344503004photos div {float:left;width:72px;}#yiv1344503004 
#yiv1344503004photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv1344503004 
#yiv1344503004photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1344503004
 #yiv1344503004reco-category {font-size:77%;}#yiv1344503004 

RE: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

[Thomas Kragh t...@uvdata.dk [firebird-support]]

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 t...@uvdata.dk  Web www.uvdata.dk
Telefon +45 72287030

[http://res.uvdata.net/mailsignatur/kmdsammenudviklervidanmark.jpg]

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.

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

on another table,same db, with 7 records and  12 columns takes  2.362s
select * from table2

Starting transaction...Preparing statement: ..Statement prepared (elapsed time: 
0.043s).
Executing statement...Statement executed (elapsed time: 0.000s).22475 fetches, 
6 marks, 1 reads, 6 writes.0 inserts, 0 updates, 0 deletes, 237 index, 10491 
seq.Delta memory: 37192 bytes.Total execution time: 2.362sScript execution 
finished.
I have a mysql hosting (on another provider) that support remote access don't 
know how is configured but every query is very fast,on manager or by an 
application ex:
 SELECT * FROM tabletest ORDER BY data desc 
 66 row(s) returned 0.063 sec
10 fields

thanks
  From: "'Mr. John' mr_joh...@yahoo.com [firebird-support]" 

 To: "firebird-support@yahoogroups.com"  
 Sent: Friday, April 14, 2017 9:29 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
    hi.I put only 2 columns but seems the same result


  From: "'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]" 

 To: "firebird-support@yahoogroups.com"  
 Sent: Friday, April 14, 2017 9:13 PM
 Subject: RE: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
  
      hi Min=37ms Max=37ms Avg=37ms     Does mean that but only 
selecting specific columns, your SQL executed faster?     Also, are using 
v2.5+ FBClient library on remote client?    thanks    From: "'Leyne, 
Sean's...@broadviewsoftware.com [firebird-support]" 

To: "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?     
  

 #yiv7401092028 #yiv7401092028 -- #yiv7401092028ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7401092028 
#yiv7401092028ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7401092028 
#yiv7401092028ygrp-mkp #yiv7401092028hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv7401092028 #yiv7401092028ygrp-mkp #yiv7401092028ads 
{margin-bottom:10px;}#yiv7401092028 #yiv7401092028ygrp-mkp .yiv7401092028ad 
{padding:0 0;}#yiv7401092028 #yiv7401092028ygrp-mkp .yiv7401092028ad p 
{margin:0;}#yiv7401092028 #yiv7401092028ygrp-mkp .yiv7401092028ad a 
{color:#ff;text-decoration:none;}#yiv7401092028 #yiv7401092028ygrp-sponsor 
#yiv7401092028ygrp-lc {font-family:Arial;}#yiv7401092028 
#yiv7401092028ygrp-sponsor #yiv7401092028ygrp-lc #yiv7401092028hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7401092028 
#yiv7401092028ygrp-sponsor #yiv7401092028ygrp-lc .yiv7401092028ad 
{margin-bottom:10px;padding:0 0;}#yiv7401092028 #yiv7401092028actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7401092028 
#yiv7401092028activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7401092028
 #yiv7401092028activity span {font-weight:700;}#yiv7401092028 
#yiv7401092028activity span:first-child 
{text-transform:uppercase;}#yiv7401092028 #yiv7401092028activity span a 
{color:#5085b6;text-decoration:none;}#yiv7401092028 #yiv7401092028activity span 
span {color:#ff7900;}#yiv7401092028 #yiv7401092028activity span 
.yiv7401092028underline {text-decoration:underline;}#yiv7401092028 
.yiv7401092028attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv7401092028 .yiv7401092028attach div a 
{text-decoration:none;}#yiv7401092028 .yiv7401092028attach img 
{border:none;padding-right:5px;}#yiv7401092028 .yiv7401092028attach label 
{display:block;margin-bottom:5px;}#yiv7401092028 .yiv7401092028attach label a 
{text-decoration:none;}#yiv7401092028 blockquote {margin:0 0 0 
4px;}#yiv7401092028 .yiv7401092028bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7401092028 
.yiv7401092028bold a {text-decoration:none;}#yiv7401092028 dd.yiv7401092028last 
p a {font-family:Verdana;font-weight:700;}#yiv7401092028 dd.yiv7401092028last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7401092028 
dd.yiv7401092028last p span.yiv7401092028yshortcuts 
{margin-right:0;}#yiv7401092028 div.yiv7401092028attach-table div div a 
{text-decoration:none;}#yiv7401092028 

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

hi.I put only 2 columns but seems the same result


  From: "'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]" 

 To: "firebird-support@yahoogroups.com"  
 Sent: Friday, April 14, 2017 9:13 PM
 Subject: RE: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
      hi Min=37ms Max=37ms Avg=37ms     Does mean that but only 
selecting specific columns, your SQL executed faster?     Also, are using 
v2.5+ FBClient library on remote client?    thanks    From: "'Leyne, 
Sean's...@broadviewsoftware.com [firebird-support]" 

To: "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?     
  #yiv257666 #yiv257666 -- #yiv257666ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv257666 
#yiv257666ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv257666 
#yiv257666ygrp-mkp #yiv257666hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv257666 #yiv257666ygrp-mkp #yiv257666ads 
{margin-bottom:10px;}#yiv257666 #yiv257666ygrp-mkp .yiv257666ad 
{padding:0 0;}#yiv257666 #yiv257666ygrp-mkp .yiv257666ad p 
{margin:0;}#yiv257666 #yiv257666ygrp-mkp .yiv257666ad a 
{color:#ff;text-decoration:none;}#yiv257666 #yiv257666ygrp-sponsor 
#yiv257666ygrp-lc {font-family:Arial;}#yiv257666 
#yiv257666ygrp-sponsor #yiv257666ygrp-lc #yiv257666hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv257666 
#yiv257666ygrp-sponsor #yiv257666ygrp-lc .yiv257666ad 
{margin-bottom:10px;padding:0 0;}#yiv257666 #yiv257666actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv257666 
#yiv257666activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv257666
 #yiv257666activity span {font-weight:700;}#yiv257666 
#yiv257666activity span:first-child 
{text-transform:uppercase;}#yiv257666 #yiv257666activity span a 
{color:#5085b6;text-decoration:none;}#yiv257666 #yiv257666activity span 
span {color:#ff7900;}#yiv257666 #yiv257666activity span 
.yiv257666underline {text-decoration:underline;}#yiv257666 
.yiv257666attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv257666 .yiv257666attach div a 
{text-decoration:none;}#yiv257666 .yiv257666attach img 
{border:none;padding-right:5px;}#yiv257666 .yiv257666attach label 
{display:block;margin-bottom:5px;}#yiv257666 .yiv257666attach label a 
{text-decoration:none;}#yiv257666 blockquote {margin:0 0 0 
4px;}#yiv257666 .yiv257666bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv257666 
.yiv257666bold a {text-decoration:none;}#yiv257666 dd.yiv257666last 
p a {font-family:Verdana;font-weight:700;}#yiv257666 dd.yiv257666last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv257666 
dd.yiv257666last p span.yiv257666yshortcuts 
{margin-right:0;}#yiv257666 div.yiv257666attach-table div div a 
{text-decoration:none;}#yiv257666 div.yiv257666attach-table 
{width:400px;}#yiv257666 div.yiv257666file-title a, #yiv257666 
div.yiv257666file-title a:active, #yiv257666 
div.yiv257666file-title a:hover, #yiv257666 div.yiv257666file-title 
a:visited {text-decoration:none;}#yiv257666 div.yiv257666photo-title a, 
#yiv257666 div.yiv257666photo-title a:active, #yiv257666 
div.yiv257666photo-title a:hover, #yiv257666 
div.yiv257666photo-title a:visited {text-decoration:none;}#yiv257666 
div#yiv257666ygrp-mlmsg #yiv257666ygrp-msg p a 
span.yiv257666yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv257666 
.yiv257666green {color:#628c2a;}#yiv257666 .yiv257666MsoNormal 
{margin:0 0 0 0;}#yiv257666 o {font-size:0;}#yiv257666 
#yiv257666photos div {float:left;width:72px;}#yiv257666 
#yiv257666photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv257666 
#yiv257666photos div 

RE: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Leyne, Sean' s...@broadviewsoftware.com [firebird-support]]

hi
Min=37ms Max=37ms Avg=37ms

 Does mean that but only selecting specific columns, your SQL executed 
faster?

 Also, are using v2.5+ FBClient library on remote client?

thanks


From: "'Leyne, Sean' 
s...@broadviewsoftware.com 
[firebird-support]" 
>
To: "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?

Re: [firebird-support] Re: Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

no,it doesn't
thanks


  From: "kragh.tho...@yahoo.com [firebird-support]" 

 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 9:02 PM
 Subject: [firebird-support] Re: Improve remote query speed on Windows Server 
2012 VPS
   
    Does MYTABLEcontain any blob columns with data that needs to be fetched?   
#yiv3094711705 #yiv3094711705 -- #yiv3094711705ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3094711705 
#yiv3094711705ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3094711705 
#yiv3094711705ygrp-mkp #yiv3094711705hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3094711705 #yiv3094711705ygrp-mkp #yiv3094711705ads 
{margin-bottom:10px;}#yiv3094711705 #yiv3094711705ygrp-mkp .yiv3094711705ad 
{padding:0 0;}#yiv3094711705 #yiv3094711705ygrp-mkp .yiv3094711705ad p 
{margin:0;}#yiv3094711705 #yiv3094711705ygrp-mkp .yiv3094711705ad a 
{color:#ff;text-decoration:none;}#yiv3094711705 #yiv3094711705ygrp-sponsor 
#yiv3094711705ygrp-lc {font-family:Arial;}#yiv3094711705 
#yiv3094711705ygrp-sponsor #yiv3094711705ygrp-lc #yiv3094711705hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3094711705 
#yiv3094711705ygrp-sponsor #yiv3094711705ygrp-lc .yiv3094711705ad 
{margin-bottom:10px;padding:0 0;}#yiv3094711705 #yiv3094711705actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3094711705 
#yiv3094711705activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3094711705
 #yiv3094711705activity span {font-weight:700;}#yiv3094711705 
#yiv3094711705activity span:first-child 
{text-transform:uppercase;}#yiv3094711705 #yiv3094711705activity span a 
{color:#5085b6;text-decoration:none;}#yiv3094711705 #yiv3094711705activity span 
span {color:#ff7900;}#yiv3094711705 #yiv3094711705activity span 
.yiv3094711705underline {text-decoration:underline;}#yiv3094711705 
.yiv3094711705attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3094711705 .yiv3094711705attach div a 
{text-decoration:none;}#yiv3094711705 .yiv3094711705attach img 
{border:none;padding-right:5px;}#yiv3094711705 .yiv3094711705attach label 
{display:block;margin-bottom:5px;}#yiv3094711705 .yiv3094711705attach label a 
{text-decoration:none;}#yiv3094711705 blockquote {margin:0 0 0 
4px;}#yiv3094711705 .yiv3094711705bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3094711705 
.yiv3094711705bold a {text-decoration:none;}#yiv3094711705 dd.yiv3094711705last 
p a {font-family:Verdana;font-weight:700;}#yiv3094711705 dd.yiv3094711705last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3094711705 
dd.yiv3094711705last p span.yiv3094711705yshortcuts 
{margin-right:0;}#yiv3094711705 div.yiv3094711705attach-table div div a 
{text-decoration:none;}#yiv3094711705 div.yiv3094711705attach-table 
{width:400px;}#yiv3094711705 div.yiv3094711705file-title a, #yiv3094711705 
div.yiv3094711705file-title a:active, #yiv3094711705 
div.yiv3094711705file-title a:hover, #yiv3094711705 div.yiv3094711705file-title 
a:visited {text-decoration:none;}#yiv3094711705 div.yiv3094711705photo-title a, 
#yiv3094711705 div.yiv3094711705photo-title a:active, #yiv3094711705 
div.yiv3094711705photo-title a:hover, #yiv3094711705 
div.yiv3094711705photo-title a:visited {text-decoration:none;}#yiv3094711705 
div#yiv3094711705ygrp-mlmsg #yiv3094711705ygrp-msg p a 
span.yiv3094711705yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3094711705 
.yiv3094711705green {color:#628c2a;}#yiv3094711705 .yiv3094711705MsoNormal 
{margin:0 0 0 0;}#yiv3094711705 o {font-size:0;}#yiv3094711705 
#yiv3094711705photos div {float:left;width:72px;}#yiv3094711705 
#yiv3094711705photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv3094711705 
#yiv3094711705photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3094711705
 #yiv3094711705reco-category {font-size:77%;}#yiv3094711705 
#yiv3094711705reco-desc {font-size:77%;}#yiv3094711705 .yiv3094711705replbq 
{margin:4px;}#yiv3094711705 #yiv3094711705ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv3094711705 #yiv3094711705ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3094711705 
#yiv3094711705ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3094711705 
#yiv3094711705ygrp-mlmsg select, #yiv3094711705 input, #yiv3094711705 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3094711705 
#yiv3094711705ygrp-mlmsg pre, #yiv3094711705 code {font:115% 
monospace;}#yiv3094711705 #yiv3094711705ygrp-mlmsg * 
{line-height:1.22em;}#yiv3094711705 #yiv3094711705ygrp-mlmsg #yiv3094711705logo 
{padding-bottom:10px;}#yiv3094711705 #yiv3094711705ygrp-msg p a 
{font-family:Verdana;}#yiv3094711705 #yiv3094711705ygrp-msg 

[firebird-support] Re: Improve remote query speed on Windows Server 2012 VPS

[kragh.tho...@yahoo.com [firebird-support]]

Does MYTABLE contain any blob columns with data that needs to be fetched? 

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

hiMin=37ms Max=37ms Avg=37ms
thanks

  From: "'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]" 

 To: "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?

  #yiv7478938356 #yiv7478938356 -- #yiv7478938356ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7478938356 
#yiv7478938356ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7478938356 
#yiv7478938356ygrp-mkp #yiv7478938356hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv7478938356 #yiv7478938356ygrp-mkp #yiv7478938356ads 
{margin-bottom:10px;}#yiv7478938356 #yiv7478938356ygrp-mkp .yiv7478938356ad 
{padding:0 0;}#yiv7478938356 #yiv7478938356ygrp-mkp .yiv7478938356ad p 
{margin:0;}#yiv7478938356 #yiv7478938356ygrp-mkp .yiv7478938356ad a 
{color:#ff;text-decoration:none;}#yiv7478938356 #yiv7478938356ygrp-sponsor 
#yiv7478938356ygrp-lc {font-family:Arial;}#yiv7478938356 
#yiv7478938356ygrp-sponsor #yiv7478938356ygrp-lc #yiv7478938356hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7478938356 
#yiv7478938356ygrp-sponsor #yiv7478938356ygrp-lc .yiv7478938356ad 
{margin-bottom:10px;padding:0 0;}#yiv7478938356 #yiv7478938356actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7478938356 
#yiv7478938356activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7478938356
 #yiv7478938356activity span {font-weight:700;}#yiv7478938356 
#yiv7478938356activity span:first-child 
{text-transform:uppercase;}#yiv7478938356 #yiv7478938356activity span a 
{color:#5085b6;text-decoration:none;}#yiv7478938356 #yiv7478938356activity span 
span {color:#ff7900;}#yiv7478938356 #yiv7478938356activity span 
.yiv7478938356underline {text-decoration:underline;}#yiv7478938356 
.yiv7478938356attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv7478938356 .yiv7478938356attach div a 
{text-decoration:none;}#yiv7478938356 .yiv7478938356attach img 
{border:none;padding-right:5px;}#yiv7478938356 .yiv7478938356attach label 
{display:block;margin-bottom:5px;}#yiv7478938356 .yiv7478938356attach label a 
{text-decoration:none;}#yiv7478938356 blockquote {margin:0 0 0 
4px;}#yiv7478938356 .yiv7478938356bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7478938356 
.yiv7478938356bold a {text-decoration:none;}#yiv7478938356 dd.yiv7478938356last 
p a {font-family:Verdana;font-weight:700;}#yiv7478938356 dd.yiv7478938356last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7478938356 
dd.yiv7478938356last p span.yiv7478938356yshortcuts 
{margin-right:0;}#yiv7478938356 div.yiv7478938356attach-table div div a 
{text-decoration:none;}#yiv7478938356 div.yiv7478938356attach-table 
{width:400px;}#yiv7478938356 div.yiv7478938356file-title a, #yiv7478938356 
div.yiv7478938356file-title a:active, #yiv7478938356 
div.yiv7478938356file-title a:hover, #yiv7478938356 div.yiv7478938356file-title 
a:visited {text-decoration:none;}#yiv7478938356 div.yiv7478938356photo-title a, 
#yiv7478938356 div.yiv7478938356photo-title a:active, #yiv7478938356 
div.yiv7478938356photo-title a:hover, #yiv7478938356 
div.yiv7478938356photo-title a:visited {text-decoration:none;}#yiv7478938356 
div#yiv7478938356ygrp-mlmsg #yiv7478938356ygrp-msg p a 
span.yiv7478938356yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7478938356 
.yiv7478938356green {color:#628c2a;}#yiv7478938356 .yiv7478938356MsoNormal 
{margin:0 0 0 0;}#yiv7478938356 o {font-size:0;}#yiv7478938356 
#yiv7478938356photos div {float:left;width:72px;}#yiv7478938356 
#yiv7478938356photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv7478938356 
#yiv7478938356photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7478938356
 #yiv7478938356reco-category {font-size:77%;}#yiv7478938356 
#yiv7478938356reco-desc {font-size:77%;}#yiv7478938356 .yiv7478938356replbq 
{margin:4px;}#yiv7478938356 #yiv7478938356ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv7478938356 #yiv7478938356ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7478938356 
#yiv7478938356ygrp-mlmsg table 

RE: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Leyne, Sean' s...@broadviewsoftware.com [firebird-support]]

> 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?

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Hi.I put  TcpRemoteBufferSize  32767   (i've restarted the Fb service) but I 
don't see major differences,same results:
Total execution time: 6.662s
I've done tests also with zebedee but no improvements
thanks

  From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" 

 To: firebird-support@yahoogroups.com 
 Sent: Friday, April 14, 2017 2:30 PM
 Subject: Re: [firebird-support] Improve remote query speed on Windows Server 
2012 VPS
   
14.04.2017 8:22, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> How can I improve remote speed?

  Increase value of "TcpRemoteBufferSize" parameter in firebird.conf to max.


-- 
  WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links





   

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

14.04.2017 8:22, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> How can I improve remote speed?

   Increase value of "TcpRemoteBufferSize" parameter in firebird.conf to max.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Improve remote query speed on Windows Server 2012 VPS

['Mr. John' mr_joh...@yahoo.com [firebird-support]]

Hi.I'm testing Firebird 2.5 x64 on Windows Server 2012 R2 VPSFrom 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