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 [email protected] [firebird-support]"
<[email protected]>
To: [email protected]
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' [email protected] [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
