I have a problem with a procedure that is calling another procedure.
Pasting some code:
Expand|Select|Wrap|Line Numbers
- INSERT INTO LOGGING.POTRDITEV_FAKTURE(A,B,C) VALUES(4, 'POTRDITEV_FAKTURE_DODATEK ZA FAKT_ID = '||TRIM(CHAR(NFAKT_ID)), CURRENT TIMESTAMP);
- CALL POTRDITEV_FAKTURE_DODATEK(NFAKT_ID, XPODR_ID, XVRDO_ID, XFAKT_FAKTURA, XTBLA_ID, XDELA_ID, XPART_ID, XPART_ID_KUPEC, XPATI_ID, XFAKT_FINSTFAKTURE);
- INSERT INTO LOGGING.POTRDITEV_FAKTURE(A,B,C) VALUES(5, 'VEZAPOSGFAKTVPRIPRAVI ZA FAKT_ID = '||TRIM(CHAR(NFAKT_ID)), CURRENT TIMESTAMP);
Log of procedure 1 shows start time of call to procedure:
20.4.2010 13:30:02.343000
end time:
20.4.2010 13:30:03.062000
Procedure 2 shows it's start time:20.4.2010 13:30:02.468000
end time:
20.4.2010 13:30:02.484000
I am wandering if there is a db parameter like (package size ) or anything that could help me minimize the time between call of procedure b inside of procedure a.
Hope i made my question clear.
I tryed with rebinding packages, did reorgs, runstats....
thanks for any information you might share.
LP
Marko