Hallo, Il 08/01/2016 16.30, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] ha scritto: > You have to sort out where your current bottleneck is. > > Can you pin-point it to a particular query or is performance in general > bad? With Firebird 2.5, you have quite some monitoring amory, e.g. > monitoring tables (tables starting with MON$...) or the Trace API.
The performance is bad in general, the navigation on a tables are too slow. I find the problem, it's me that i used ZeosLib property "SortedFields" on a TQuery" component. > Increase "Page buffers" to e.g. 10000 (e.g. with gfix command-line > tool), then re-connect your client application and see if this helps. Before I Find the problem, seems not helps, it's a bit well but not helps. > There is other tuning stuff, I'm reading the Firebird Book written by Helen Borrie to understand the usage of FB but is hard reading over 1000 pages when the software must be ready for yesterday ;) There are some other pages to read for undestrand the tuning of FB? > getting a big picture on your slow statements, their > execution plan probably pointing to missing indexes ... is a good start. This helped me to find the problem. > Good luck. Thank you -- <pre> Luigi Siciliano -------------------------- </pre> ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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/