Uploaded image for project: 'FishEye'
  1. FishEye
  2. FE-4547

User admin screen fetches the whole user list one by one

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Medium
    • 3.6.0
    • 2.10.0
    • None

    Description

      When showing the user list we seem to request the entire user list for each request, and then make a separate select for every user in the system to fetch the details. (UserAdminAction.execute())

      2013-03-05 10:25:41,069 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_name as col_0_0_ from cru_user user0_ where user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true order by user0_.cru_user_name
      2013-03-05 10:25:41,174 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:41,281 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:41,389 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:41,491 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:41,624 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:41,761 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:41,858 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:41,955 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:42,055 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:42,153 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:42,247 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:42,343 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:42,439 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:42,536 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:42,632 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:42,740 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:42,839 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:42,937 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:43,041 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:43,226 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      2013-03-05 10:25:43,321 DEBUG [qtp719724423-1083 - /foo/admin/userAdmin.do ] org.hibernate.SQL SQLStatementLogger-logStatement - select user0_.cru_user_id as cru1_14_, user0_.cru_user_name as cru2_14_, user0_.cru_email as cru3_14_, user0_.cru_passwordhash as cru4_14_, user0_.cru_authtype as cru5_14_, user0_.cru_displayname as cru6_14_, user0_.cru_fisheye_enabled as cru7_14_, user0_.cru_crucible_enabled as cru8_14_, user0_.cru_passwordreset_srnd as cru9_14_, user0_.cru_passwordresettimestamp as cru10_14_, user0_.cru_failedlogincount as cru11_14_, user0_.cru_timezone as cru12_14_ from cru_user user0_ where user0_.cru_user_name=? and (user0_.cru_fisheye_enabled=true or user0_.cru_crucible_enabled=true)
      

      Also when admin groups are configured, each user is checked for membership in each of the groups, which might be expensive when using JIRA/Crowd for user management.

      Attachments

        Issue Links

          Activity

            People

              cmacneill Conor
              lpater Lukasz Pater
              Votes:
              3 Vote for this issue
              Watchers:
              3 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 - 2h 5m
                  2h 5m