> Hallo, > > Il 08/01/2016 16.22, Tim Ward t...@telensa.com [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. ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/