Subject | Re: [firebird-support] Small Database with very very bad performance on LAN |
---|---|
Author | Luigi Siciliano |
Post date | 2016-01-08T17:46:25Z |
Hallo,
Il 08/01/2016 16.22, Tim Ward tdw@... [firebird-support] ha scritto:
Investigating for query plans, statistics, Buffers as suggested by
Thomas, I discovered the origin of the problem:
FB is innocent :) the guilty is me because I use ZEOSLib to connect to
FB and I used the property "SortedFields" instead of using the clause
"ORDER BY" in SQL query thinking that is more flexible on a Delphi RAD
development like Delphi :(
Now the application seems faster and works best of the same application
that use BDE :)
Thanks to all.
--
<pre>
Luigi Siciliano
--------------------------
</pre>
Il 08/01/2016 16.22, Tim Ward tdw@... [firebird-support] ha scritto:
> What are your queries, query plans, query statistics?The queries are similar to: SELECT * FROM TABLE.
Investigating for query plans, statistics, Buffers as suggested by
Thomas, I discovered the origin of the problem:
FB is innocent :) the guilty is me because I use ZEOSLib to connect to
FB and I used the property "SortedFields" instead of using the clause
"ORDER BY" in SQL query thinking that is more flexible on a Delphi RAD
development like Delphi :(
Now the application seems faster and works best of the same application
that use BDE :)
Thanks to all.
--
<pre>
Luigi Siciliano
--------------------------
</pre>