Hello,

I'm no IB/FB expert (working hard on it... ;-)) , but my first first thought
was, to write an UDF which writes a logfile with timestamps. Place the
function call in different places inside your SP and UDF's, so you might
see when FB is doing something at which time. I never wrote UDF's, so I
don't know if there are some limitations in calling UDFs from SPs or another
UDF.

Ulrich



""mircostange"" <mirco@...> schrieb im Newsbeitrag
news:ao5sjf+5d9h@......

> 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?
>
> No one out there having an idea on this or is this just the wrong
> group?
>
> Thanks anyway
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>