-
Bug
-
Resolution: Fixed
-
High
-
5.9.0, 6.0.7
-
1
-
Severity 3 - Minor
-
1
-
Summary
User profile (and possibly User list and User Status List) macros exhibit poor performance since the removal of Status updates.
See CONFSERVER-38253 for comments
Environment
- Confluence server version 5.9.x and above
Steps to Reproduce
- Add affected macro(s) to a page. (multiple macros may be required to visibly observe issue)
- View page
Expected Results
Page renders quickly
Actual Results
Page rendering is slow.
- is a regression of
-
CONFSERVER-38253 Plans to remove status updates
- Closed
- is detailed by
-
-
- Closed
-
- is related to
-
-
- Closed
-
- mentioned in
-
![[Extranet] Page](/images/icons/generic_link_16.png "[Extranet] Page")
Page
Failed to load
| Form Name | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
[CONFSERVER-52544] User profile macro slow performance
GRPG04162, to be clear, whilst this bug has been back ported to 6.6.x, it is due to the critical nature of the performance impact. Only bugs that impact performance or stability will be back ported to an Enterprise Release, not all bug fixes.
Hi,
This issue is going to be shipped in 6.6.7, which you can expect in the next couple of weeks.
It says it's fixed on 6.7.0. Was it also fixed in 6.6.6 ? I thought all bugs will be fixed in the enterprise release which is 6.6.6.
Cheers,
Gaj
When CONFSERVER-52429 releases, this issue should be fixed as well
Hi
we use Confluence in version 6.4.3 and percona mysql 5.6.38.
And i found some Jira Tickets for Confluence and Slow User Profile Macro:
User Profile Macro can be slow to load when using MySQL
Plans to remove status updates
In the last ticket we found the solution:
before the change: The loading time for a page with 10 User Profile Macros was ~45sec
after the change: The loading time for a page with 10 User Profile Macros was ~ 3sec
And the fix was (via mysql query):
CREATE INDEX c_contenttype_idx on CONTENT (CONTENTTYPE);
I have tested a page with 500 user profile, however I could not see the performance problem. tbusby, sirko.manthey1769006974, s.pisarenka1632809988, how many user profiles do you have on your page? Are there more detailed steps or information (e.g, database name&version) to reproduce the problem? I guess it is not caused by the same issue as we see in user list macro.
This issue may become resolved by virtue of addressing CONFSERVER-54168: Confluence crashes with user list macro
Repro on Confluence Server 6.4.3. All our project main pages became unusable (loading time around 20 seconds) and we now need to modify them all rendering them less user friendly since meaningful team overviews is no longer possible.
If you're running the Confluence 6.6 Enterprise release, a fix for this issue is now available in Confluence 6.6.7, which you can find in the Download Archives.