Subject RE: [firebird-support] Firebird trace and EXECUTE_STATEMENT_FINISH
Author Svend Meyland Nicolaisen

Hi again

 

Sorry for the question. The answer is right there in the documentation at ibphoenix. “Finish is only traced, if execution time of the logged statement exceeds the value of this parameter”.

 

/Svend

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Svend Meyland Nicolaisen
Sent: Tuesday, March 04, 2014 2:46 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Firebird trace and EXECUTE_STATEMENT_FINISH

 

 

Hi

 

I am using the trace functionality of Firebird 2.5.2. Can anybody tell me why EXECUTE_STATEMENT_FINISH only is logged for some statements. For most of my statements I get the following sequence in the trace:

 

PREPARE_STATEMENT

EXECUTE_STATEMENT_START

CLOSE_CURSOR

FREE_STATEMENT

 

And occasionally I get:

 

PREPARE_STATEMENT

EXECUTE_STATEMENT_START

EXECUTE_STATEMENT_FINISH

CLOSE_CURSOR

FREE_STATEMENT

 

Kind regards,

Svend Meyland Nicolaisen