Subject Need help for optimization / profiler
Author mircostange
I need some help to analyze the execution of a number of queries to
get a hint on possible optimizations. The queries are issued by
Crystal Reports and mainly rely on a select-procedure that in turn
uses some stored procedures and UDFs. As execution is slow, I would
like to analyze how much time FB spends in the stored procedures,
UDFs etc to see which of the parts is worth optimizing.

I am familiar with this approach for programs written in a
programming language, e.g. using TrueTime. Is there something similar
to this for FB?

I have also been thinking about using the ODBC-drivers logs to
analyze, but this doesn't show me usage of SPs/UDFs called by the
select statement individually.