>> 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
>
>
>