Execute Stored Procedure Trace Logging

Thanks James, Could you please help with definitions of below parameters in the file.

Datasource Lookup Time (ms) ----?

Datasource Connect Time (ms) ---?
Validate Time (ms) ---?
Prepare Time (ms) ---?
Execute Time (ms) ---?
Transform Time (ms) ---> Time taken to transform the data into Appian readable format.
Total Time (ms)--> Time taken to execute the stored procedure.

Datasource Connect Time (ms) --> Time taken to connect to database / retrieve from connection pool. This time may be higher if a brand new connection was required vs one already available from the pool

Validate Time (ms) --> Time taken to verify the configured inputs and outputs match an available stored procedure. Metadata about existing stored procs is queried from the database to compare against what the designer provided.

Prepare Time (ms) --> Time taken to register the upcoming execution request with the database, set inputs and register request for response outputs

Execute Time (ms) --> Time taken for database to execute the stored proc

Transform Time (ms) --> Time taken to transform the data into Appian's internal data structure

Total Time (ms) --> Total time of all points above

Datasource Connect Time (ms) --> Time taken to connect to database / retrieve from connection pool. This time may be higher if a brand new connection was required vs one already available from the pool

Validate Time (ms) --> Time taken to verify the configured inputs and outputs match an available stored procedure. Metadata about existing stored procs is queried from the database to compare against what the designer provided.

Prepare Time (ms) --> Time taken to register the upcoming execution request with the database, set inputs and register request for response outputs

Execute Time (ms) --> Time taken for database to execute the stored proc

Transform Time (ms) --> Time taken to transform the data into Appian's internal data structure

Total Time (ms) --> Total time of all points above

Hi James Carter, sorry for reviving this old thread. But would you have any idea on how we can improve the Validate time?

We're trying to optimize calls to SP on Oracle and checking on the logs, Validate Time takes almost >70% of the total time. 

Thanks

There is a comment thread on the AppMarket listing for Execute Stored Procedure where others have discussed this and shared a solution. I recommend working with the DBA for your database to understand if this or another option is available.

community.appian.com/.../execute-stored-procedure