]> source.dussan.org Git - sonarqube.git/commit
Specify data types on inserts into project_measures 47/head
authorStephen Kitt <steve@sk2.org>
Tue, 16 Dec 2014 18:49:51 +0000 (19:49 +0100)
committerStephen Kitt <steve@sk2.org>
Tue, 16 Dec 2014 18:49:51 +0000 (19:49 +0100)
commit023d6d9fe305d8c09e3971ba351df1325773d2c1
tree5eadbf0c675a68bdeb2c26f1c48d2bf47a4a36ae
parenta6320e1ba094d3d42a90e7ec871b1b04a9998a53
Specify data types on inserts into project_measures

At least when using Oracle databases, projects with large volumes of
updates (over a million inserts per hour) see lots of cursor
contention, accounting for up to 40% of the database's activity (after
adjusting the shared pool size appropriately). This is due to the
presence of null values where the database can't determine the data
type, and therefore has to try different variants of the statement.

Specifying the data types on the non-blob columns avoids the type
uncertainty, and solves the cursor contention.

Signed-off-by: Stephen Kitt <steve@sk2.org>
sonar-plugin-api/src/main/resources/org/sonar/api/database/model/MeasureMapper.xml