|Subject||Re: [firebird-support] Small Database with very very bad performance on LAN|
> Hallo,A great use case for the Firebird Trace API to investigate what's up
> 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 :(
behind the scene of ZEOS. ;-)
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.