Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
When opening a new transaction we issue 2 queries to update the MIN_OPEN_TXN table.
<SELECT MIN("TXN_ID") FROM "TXNS" WHERE "TXN_STATE" = 'o'> <insert into "MIN_HISTORY_LEVEL" ("MHL_TXNID", "MHL_MIN_OPEN_TXNID") values(763, 763)>
This could be archived with a single query faster, if we do not open transactions in batch, like:
<INSERT INTO "MIN_HISTORY_LEVEL" ("MHL_TXNID", "MHL_MIN_OPEN_TXNID") SELECT ?, MIN("TXN_ID") FROM "TXNS" WHERE "TXN_STATE" = 'o'>