Subject Re: [ib-support] 3rd attempt: HELP needed for optimization
Author Ann W. Harrison
At 06:54 AM 10/11/2002 +0000, mircostange wrote:
>Still didn't have any feedback regarding optimization support. The
>issue is: how can I analyze how much time IB/FB spends with the
>execution of a number complex queries involving UDFs and stored
>procedures to get a hint why those queries are relatively slow?

At the moment there are no tools built into Firebird that track
the individual queries. The performance monitoring calls are
designed for user-written clients, so they won't help find the
problem that shows up with Crystal reports. So, the answer is
boring and simple. Write a program that executes the queries
that your reports generate and analyze the performance through
that program.


We have answers.