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]"
<firebird-support@yahoogroups.com>
To: Firebird-support <firebird-support@yahoogroups.com>
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:#0000ff;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
#666666;height:62px;overflow:hidden;width:62px;}#yiv1344503004
#yiv1344503004photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1344503004
#yiv1344503004reco-category {font-size:77%;}#yiv1344503004
#yiv1344503004reco-desc {font-size:77%;}#yiv1344503004 .yiv1344503004replbq
{margin:4px;}#yiv1344503004 #yiv1344503004ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1344503004 #yiv1344503004ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1344503004
#yiv1344503004ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1344503004
#yiv1344503004ygrp-mlmsg select, #yiv1344503004 input, #yiv1344503004 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1344503004
#yiv1344503004ygrp-mlmsg pre, #yiv1344503004 code {font:115%
monospace;}#yiv1344503004 #yiv1344503004ygrp-mlmsg *
{line-height:1.22em;}#yiv1344503004 #yiv1344503004ygrp-mlmsg #yiv1344503004logo
{padding-bottom:10px;}#yiv1344503004 #yiv1344503004ygrp-msg p a
{font-family:Verdana;}#yiv1344503004 #yiv1344503004ygrp-msg
p#yiv1344503004attach-count span {color:#1E66AE;font-weight:700;}#yiv1344503004
#yiv1344503004ygrp-reco #yiv1344503004reco-head
{color:#ff7900;font-weight:700;}#yiv1344503004 #yiv1344503004ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1344503004 #yiv1344503004ygrp-sponsor
#yiv1344503004ov li a {font-size:130%;text-decoration:none;}#yiv1344503004
#yiv1344503004ygrp-sponsor #yiv1344503004ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1344503004
#yiv1344503004ygrp-sponsor #yiv1344503004ov ul {margin:0;padding:0 0 0
8px;}#yiv1344503004 #yiv1344503004ygrp-text
{font-family:Georgia;}#yiv1344503004 #yiv1344503004ygrp-text p {margin:0 0 1em
0;}#yiv1344503004 #yiv1344503004ygrp-text tt {font-size:120%;}#yiv1344503004
#yiv1344503004ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1344503004
