> 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
http://www.upscene.com/

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