Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-5729

getUsersWithConfluenceAccess() is very slow

    XMLWordPrintable

Details

    Description

      getUsersWithConfluenceAccess() is pure evil. With any reasonably-sized userbase, It grinds even the most helpful server to a halt.

      Currently it's called from three or four different places:

      1) License check
      2) Adding a new user
      3) Whenever the license check cache expires

      We should find alternatives, and ensure that the method is never called for anything but the license check when:

      1) External user management is enabled
      2) select count(*) from users > 1000

      We should also just disable the license check entirely for unlimited-user licenses (i.e. 10,000 user licenses or more). Right now this limits our ability to offer licensing schemes >10,000 users per license, but tough, this is hurting us now.

      Attachments

        Issue Links

          Activity

            People

              matt@atlassian.com Matt Ryall
              cmiller CharlesA
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 2h
                  2h
                  Remaining:
                  Remaining Estimate - 2h
                  2h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified