Details
-
Bug
-
Resolution: Fixed
-
Medium
-
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.