| Subject | Re: [firebird-support] Fast Slow Stored procedure |
|---|---|
| Author | |
| Post date | 2016-05-05T07:20:52Z |
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
Jack
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
Jack