Hi Jack, > Hi Thomas > > I did a trace as you suggested. > The slow SP shows these 3 consecutive statements showing a 20 min gap of > no activity > > 2016-05-04T14:25:30.5020 (3268:061B51F8) EXECUTE_PROCEDURE_START > C:\MAGUSDB\FBDB\SAMPLE1.FDB (ATT_45, SYSDBA:NONE, NONE, TCPv4:127.0.0.1) > C:\Magus\Magus C++\Latest Developement IBO Test\MagusManager.exe:8304 > (TRA_382, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE) > > Procedure CLEAR_BUILD_DXS: > param0 = integer, "0" > > > 2016-05-04T14:45:39.7880 (3268:061B51F8) PREPARE_STATEMENT > C:\MAGUSDB\FBDB\SAMPLE1.FDB (ATT_45, SYSDBA:NONE, NONE, TCPv4:127.0.0.1) > C:\Magus\Magus C++\Latest Developement IBO Test\MagusManager.exe:8304 > (TRA_382, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE) > > Statement 605: > ------------------------------------------------------------------------------- > Insert into TEMP_IMPORT_DXS (DXS_NO, ABS_NO, DB, DW, VALUE1, USED, > SPACE, UOP, EOL) > select DXS_NO, ABS_NO, DB, DW, VALUE1, USED, SPACE, UOP, EOL > from IMPORT_DXS > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > The fast SP there is a only a small gap > > 2016-05-05T07:24:05.3290 (3268:061B51F8) EXECUTE_PROCEDURE_START > C:\MAGUSDB\FBDB\SAMPLE1.FDB (ATT_52, SYSDBA:NONE, NONE, TCPv4:127.0.0.1) > C:\Magus\Magus C++\Latest Developement IBO Test\MagusManager.exe:5636 > (TRA_417, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE) > > Procedure CLEAR_BUILD_DXS: > param0 = integer, "0" > > > 2016-05-05T07:24:13.4540 (3268:061B51F8) PREPARE_STATEMENT > C:\MAGUSDB\FBDB\SAMPLE1.FDB (ATT_52, SYSDBA:NONE, NONE, TCPv4:127.0.0.1) > C:\Magus\Magus C++\Latest Developement IBO Test\MagusManager.exe:5636 > (TRA_417, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE) > > Statement 605: > ------------------------------------------------------------------------------- > Insert into TEMP_IMPORT_DXS (DXS_NO, ABS_NO, DB, DW, VALUE1, USED, > SPACE, UOP, EOL) > select DXS_NO, ABS_NO, DB, DW, VALUE1, USED, SPACE, UOP, EOL > from IMPORT_DXS > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > Can you make any suggestion as to what happened for 20 min
No, sorry. You either have removed parts of the trace or you need a different trace configuration, particular the various *_FINISH entries, which usually print out the execution time. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
