Slow analysis after SonarQube upgrade

[chrism (Chris)]

@guwirth Out of curiosity what version of Postgres are you using?

We got a perf bump out of going up to Postgres version 15.4 from 12, still nowhere near as fast as we were on Sonar 9.9 though

[guwirth (Günter Wirth)]

Out of curiosity what version of Postgres are you using?

We are using the Embedded Database for integration tests. Download and unzip it and start the tests. Same machines, same tests with SQ 9.9 LTS, SQ 10.7 and Community Build 24.12.0.100206. SQ 9.9 LTS is about 3 times faster.

[Colin]

Hey @chrism

I suppose we’ve had so much going on (Standard Mode vs. MQR) that refactoring a database table for performance was left on the cutting room floor for release notes.

@guwirth Thanks for your update. I’ve escalated this internally.

[Colin]

Another update:

SonarQube 10.x 3 times slower compared to 9.9 LTS

Hey @guwirth We have implemented several tickets that will be available in the next release to bring the total analysis time (scanner + Compute Engine) closer to the prior performance. SONAR-22998 - Optimize loading of active rules from the scanner SONAR-24006 - Big regression in the Compute Engine step “Load quality profiles” SONAR-23974 - Use enums for impacts in the scanner report to its reduce size SONAR-24057 - Optimize querying of measures to only load required measures in memory I …

[guwirth (Günter Wirth)]

Hi @Colin,

did a first test with sonarqube-25.1.0.102122; times are much better now: Still 13% slower but no more factor 3!

Thanks for your support.

Günter