Subject | Need help for optimization / profiler |
---|---|
Author | mircostange |
Post date | 2002-10-10T08:17:57Z |
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.
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.