Skip to content
Blame Permalink
  • Norvald H. Ryeng's avatar
    3ea48a13
    Bug #29368543 USE SINGLE TRANSACTION INSTEAD OF CREATE SRS STATEMENTS · 3ea48a13
    Norvald H. Ryeng authored 
    IN UPGRADE

Switch from CREATE SPATIAL REFERENCE SYSTEM statements to REPLACE
statements in upgrade code.

There are more than 5000 statements to upgrade spatial reference
systems. CREATE statements start a new transaction for each statement,
but REPLACE statements can be run in the same transaction, thereby
significantly reducing the time it takes to upgrade.

Change-Id: I878335dd5dd459c5a6ec6910ac758aa0ac8e6328
    3ea48a13
    Bug #29368543 USE SINGLE TRANSACTION INSTEAD OF CREATE SRS STATEMENTS
    Norvald H. Ryeng authored 
    IN UPGRADE

Switch from CREATE SPATIAL REFERENCE SYSTEM statements to REPLACE
statements in upgrade code.

There are more than 5000 statements to upgrade spatial reference
systems. CREATE statements start a new transaction for each statement,
but REPLACE statements can be run in the same transaction, thereby
significantly reducing the time it takes to upgrade.

Change-Id: I878335dd5dd459c5a6ec6910ac758aa0ac8e6328