Subject Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS
Author Mr. John
Post date 2017-04-14T19:20:46Z
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 sd@... [firebird-support]" <firebird-support@yahoogroups.com>
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_johnmr@... [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-digest@yahoogroups.com
    firebird-support-fullfeatured@yahoogroups.com

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

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