Subject Re: [firebird-support] Small Database with very very bad performance on LAN
Author Thomas Steinmaurer
> Hallo,
> 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 :(

A great use case for the Firebird Trace API to investigate what's up
behind the scene of ZEOS. ;-)

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.