Subject Re: [firebird-support] Small Database with very very bad performance on LAN
Author Luigi Siciliano

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.

Luigi Siciliano