|Subject||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
Preparing statement: ..
Statement prepared (elapsed time: 0.043s).
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
From: "'Mr. John' mr_johnmr@... [firebird-support]" <email@example.com>
To: "firstname.lastname@example.org" <email@example.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