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

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

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

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

[firebird-support] Entity Relationship Diagram

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.

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

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.

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

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

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

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

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

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

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

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,

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

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:

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

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

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

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

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

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]

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.

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

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:

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

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

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.

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

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

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

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

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:

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

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

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

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

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

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]

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

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

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]"

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.

[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