>> The Trace API is an underestimated new feature in 2.5, but a godsend to >> analyze such situations. >> > I must say I have used the lite version of your fbtracemanager tool.
Which is perfectly fine. ;-) >> Sounds a bit like running the query in a transaction with auto commit >> turned on. You might see COMMIT_RETAIN in the trace output for an >> auto-committed transaction, as this usually is the default option in the >> various access layers when using auto commit. >> >> > The problem is that the query must be executed When master/detail data is > loaded, and is executed after and using transaction for each query. Is this related to user-interaction, cause I'm curious on the frequency the query needs to be executed? -- With regards, Thomas Steinmaurer http://www.upscene.com/ > Regards, jesus >> > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > >
