Hi *,
is there some way to get "EXECUTE_STATEMENT_START" and similar when a SP (or
function) is executing some statements? No matter what I enable in my trace
config I only get i.e. "EXECUTE_PROCEDURE_START" and then i.e.
"EXECUTE_TRIGGER_START" (because the SP executed some update on a table w
28.04.2021 13:12, Jiří Činčura wrote:
Hi *,
is there some way to get "EXECUTE_STATEMENT_START" and similar when a SP (or function) is executing some statements?
There is no "separate" statements at the engine inside PSQL.
Whole SP\trigger text is a single statement.
Probably we could fin
28.04.2021 12:22, Vlad Khorsun wrote:
There is no "separate" statements at the engine inside PSQL.
Whole SP\trigger text is a single statement.
Doesn't Adriano's profiler somehow separate them?
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/li
>There is no "separate" statements at the engine inside PSQL.
> Whole SP\trigger text is a single statement.
Not good for me. :)
>Probably we could find some solution if you describe the issue you going
> to solve using trace.
Basically normal performance tracing. A SP takes for example
26.04.2021 20:11, Jiří Činčura wrote:
Hi *,
I'm looking at this
https://github.com/FirebirdSQL/firebird/blob/B3_0_Release/src/utilities/ntrace/TracePluginImpl.cpp#L1410
line and wondering how I can get that in trace's output, aka what to do in
function's/procedure's code to get something in `
Done.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 28/04/2021 07:25, Dimitry Sibiryakov wrote:
> 28.04.2021 12:22, Vlad Khorsun wrote:
>> There is no "separate" statements at the engine inside PSQL.
>> Whole SP\trigger text is a single statement.
>
> Doesn't Adriano's profiler somehow separate them?
>
Looks like it's what Jiri wants.
It
> Looks like it's what Jiri wants.
>
> It has special support for cursors and its internals record sources.
It's not probably what I want, because my focus is on processing the trace file
for kind of later/offline/post-mortem analysis.
But anyway, where I can read more?
--
Mgr. Jiří Činčura
On 28/04/2021 08:13, Jiří Činčura wrote:
>> Looks like it's what Jiri wants.
>>
>> It has special support for cursors and its internals record sources.
>
> It's not probably what I want, because my focus is on processing the trace
> file for kind of later/offline/post-mortem analysis.
>
> But a
28.04.2021 13:59, Jiří Činčura wrote:
Done.
And fixed.
Regards,
Vlad
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
28.04.2021 13:26, Jiří Činčura wrote:
There is no "separate" statements at the engine inside PSQL.
Whole SP\trigger text is a single statement.
Not good for me. :)
Probably we could find some solution if you describe the issue you going
to solve using trace.
Basically normal perfo
11 matches
Mail list logo
