I did it by writing a logging procedure which wrote timestamps to an
external file mapped to a text file, then calling it where I was interested.
An alternative is Monte Carlo profiling - I've also got a script which
polls the call stack from the RDB$ tables. The procedure or statement it
hits
Hi Tim,
Thanks for the reply. You mentioned that you did it with a logging
procedure. Can you share what you exactly what you did to accomplish this?
Mike
I think a tool like FBTraceManager from Thomas (Upscene) can do that for you
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 13 October 2015 05:31 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] How can I see which query within a store
I lost the logging code some time ago so can't quote it I'm afraid. I
defined an external table, mapped to a file, with columns for timestamp,
a couple of numeric values, and a text message. Then a procedure which
wrote a record to this table. Then called the procedure at points in my
code wher
'Louis van Alphen' lo...@nucleo.co.za [firebird-support] schrieb am 14.10.2015
10:09:
> I think a tool like FBTraceManager from Thomas (Upscene) can do that for you
Unfortunately not. The Trace API does not provide that level of granularity for
PSQL code modules.
This has been a long discussio
I see.. but I agree with you
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 14 October 2015 11:20 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How can I see which query within a stored
procedure execution takes the longest