Subject Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS
Author Mr. John
Post date 2017-04-14T18:50:26Z
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.362s
Script 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_johnmr@... [firebird-support]" <firebird-support@yahoogroups.com>
To: "firebird-support@yahoogroups.com" <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' Sean@... [firebird-support]" <firebird-support@yahoogroups.com>
To: "firebird-support@yahoogroups.com" <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
 
<SL> Does mean that but only selecting specific columns, your SQL executed faster?
 
<SL> Also, are using v2.5+ FBClient library on remote client?
 
thanks
 
From: "'Leyne, Sean' Sean@... [firebird-support]" <firebird-support@yahoogroups.com>
To: "firebird-support@yahoogroups.com" <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?