A couple of slowness were identified on artifact creation:
- Missing index
- Missing transaction
On creation of a test environment on try.tuleap-enterprise.com we went from 78s to 30s (for ~88 artifacts created during XML import)
On a platform with ~200k artifacts the SQL gains are noticable:
- Add of index: -50% of SQL time
- Add of transaction: Another -31% of SQL time
When we combine both, the creation of a new artifact goes from 330ms to 173ms of wall time (-47%). The SQL part goes from 188ms to 51ms (-73%).
Measurements where done with default "Bug" tracker.
The gain will be even better with more artifacts and/or bigger tracker (more fields).