Red Hat Bugzilla – Bug 113131
Folder browser is extremely slow when not sitewide admin
Last modified: 2007-04-18 13:01:02 EDT
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4)
Description of problem:
The folder browser uses both old and new style permission filters.
When logged in as a sitewide admin these filters aren't added in to
the query because the user has universal admin permission. When they
are executed, they run extremely slowly.
This was fixed on the london 5.2 branch by removing the old style
permission filter. Note the new one is still there, so the results are
the same. I've ported the relevant changelists to my rickshaw CMS
branch in changelist 39210.
On a populated database, a page load was taking 83 seconds. After this
change the same page was loading in .8 seconds.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Add some content to CMS.
2. Log in as a regular (non sitewide admin user).
3. Go to /ccm/content/admin and click around in the folder browser.
Actual Results: Page loads take an unacceptable amount of time (eg 83
Expected Results: Page loads take a regular amount of time.
We haven't landed the test-permissions branch yet, which completely
overhauls the permissions denormalizations. We should retest this
scenario after the land, but hopefully it should be addressed by the
i believe this is resolved now with the permissions branch land
The response time seems good just from testing, but I haven't taken
any scaling measurements. Matt, can you verify your prior test?
folder browsing survives load testing as non-sitewide-admin now