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

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

Regards, jesus

>

[Non-text portions of this message have been removed]