Uploaded image for project: 'Crucible'
  1. Crucible
  2. CRUC-6416

Optimize number of database queries for Crucible instances with Many Projects and Permission Schemes

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Low
    • 3.1.0, 3.0.2, 2.10.6
    • 2.8.1, 2.10.2, 3.0.1
    • None
    • None

    Description

      If crucible is configured with many Projects, and Permission Schemes, then when loading the list of projects a particular user has permission to create reviews in, Crucible can perform many many separate database queries.

      This can cause extreme slowness during the review creation process, especially page load times of pages containing a list of projects. e.g. Edit Details.

      The slowness is made worse when the database server is not on the same network or machine as the Crucible instance, due to the chattiness of Crucible to the SQL Database.

      Attachments

        Issue Links

          Activity

            People

              bhumphreys BrendanA
              npellow Nick
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

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