I have some information concerning areas to target for possible performance optimizations, that I hope can help in view of the upcoming work for v9.2.
Our tests were conducted on v9.0.6, using a large database set.
Test scenario
Login as Project leader (affected to only 5 small projects)
Create new project '0002-01-autre lot1', at root of project structure
=> Save operation is quick
Update project '0002-01-autre lot1', set "is sub-project of" = '0002-Test'
=> Save operation is very long, and log traces show a huge number of projects are saved.
It looks like there's something wrong in the recursive save operation, because there are no dependencies apart from the parent project and the sub-project.
Can this help to figure out what could be improved ?
Timestamps in the log file :
- First save operation : 2021-04-20 15:46:46.640 => 0.000
DEBUG
Start SAVE for Project #
- Second save operation : 2021-04-20 15:47:27.499 => 0.000
DEBUG
Start SAVE for Project #16873
If my remembering is correct, this is a "WBS renumbering" issue that was fixed on V9.1.
Do you have the opportunity ot test on V9.1 and check performance is better ?
I've tested the same scenario after upgrading to v9.1.2, but I am still seeing the same behaviour : when moving the new project to "is sub-project of" parent project, a huge number of other projects are also saved.
I checked the sortOrder, which looks ok and consistent between 'project' and 'planningelement' tables. (In this case it's project #16877 that I'm moving to sub-project of #16872).
Would you see anything else that could explain this ?
En poursuivant votre navigation, vous acceptez le dépôt de cookies tiers destinés au bon fonctionnement et à la sécurisation du site (gestion de session, reCaptcha) et à une analyse statistique anonymisée des accès sur notre site (Google Analytics). Si vous vous inscrivez, les informations que vous fournirez ne seront jamais divulguées à un tiers sous quelque forme que ce soit. En savoir plus
Cookies settings
×
Functional Cookies
Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.
Session
Please login to see yours activities!
Other cookies
Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.