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.