Symptom
A single row insert execution time could be randomly slow and varies from a few seconds to a few minutes.
The single row insert is of this form:
insert into Table1 ( col1,col2,col3,col4,col5) values( 'string1','string2','string3','string4','string5' )
This execution takes 10 seconds.
Most of the time (8 seconds) is spent between the phases:
- Time of Last Fetch Return
- Time of Complete Call
Time of Cursor Creation | 2022-03-22 15:45:34.193900 |
End of Query Block Analysis | 2022-03-22 15:45:34.202395 |
End of DFE Generation | 2022-03-22 15:45:34.822001 |
End of DFO Generation | 2022-03-22 15:45:34.822463 |
End of DFO Transforms | 2022-03-22 15:45:34.822999 |
End of DFO Shadowing | 2022-03-22 15:45:34.823143 |
End of DFO PrePrepare | 2022-03-22 15:45:34.823289 |
Time of First Prepare | 2022-03-22 15:45:34.823334 |
Time of First Prepare Return | 2022-03-22 15:45:34.824310 |
Time of First Fetch Call | 2022-03-22 15:45:34.824371 |
Time of First Fetch Return | 2022-03-22 15:45:36.705428 |
Time of Second Fetch Call | 2022-03-22 15:45:36.705429 |
Time of Last Fetch Return | 2022-03-22 15:45:36.705429 |
Time of Complete Call | 2022-03-22 15:45:44.535635 |
Time of Complete Return | 2022-03-22 15:45:44.535638 |
Total Local Condition Time | 0:00:00.000000 |
Total Time Waiting for Close | 0:00:07.830206 |
Elapsed Working Time | 0:00:02.511532 |
Elapsed Time | 0:00:10.341738 |
This execution takes 4 minutes and 26 seconds.
Most of the time (4 minutes) is spend between the phases:
- End of Query Block Analysis
- End of DFE Generation
Time of Cursor Creation | 2022-03-22 14:34:11.987914 |
End of Query Block Analysis | 2022-03-22 14:34:15.532570 |
End of DFE Generation | 2022-03-22 14:38:31.889937 |
End of DFO Generation | 2022-03-22 14:38:31.890120 |
End of DFO Transforms | 2022-03-22 14:38:31.890912 |
End of DFO Shadowing | 2022-03-22 14:38:31.891092 |
End of DFO PrePrepare | 2022-03-22 14:38:31.891306 |
Time of First Prepare | 2022-03-22 14:38:31.891352 |
Time of First Prepare Return | 2022-03-22 14:38:31.893539 |
Time of First Fetch Call | 2022-03-22 14:38:31.893655 |
Time of First Fetch Return | 2022-03-22 14:38:33.021392 |
Time of Second Fetch Call | 2022-03-22 14:38:33.021392 |
Time of Last Fetch Return | 2022-03-22 14:38:33.021392 |
Time of Complete Call | 2022-03-22 14:38:38.226407 |
Time of Complete Return | 2022-03-22 14:38:38.226408 |
Total Local Condition Time | 0:00:00.000000 |
Total Time Waiting for Close | 0:00:05.205015 |
Elapsed Working Time | 0:04:21.033479 |
Elapsed Time | 0:04:26.238494 |
Read more...
Environment
SAP IQ 16.1
Product
SAP IQ 16.1
Keywords
random, execution, "execution time" , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.