Grouper Developers Forum

[Shilen Patel <>]

Attached is a CSV file with all the SQL statements executed while the 
"Manage Groups" page was loading along with the time to execute each 
type of statement and the number of times each statement was executed.

Thanks,

-- Shilen


Michael R. Gettes wrote:
> what does "top three" mean?  Getting a breakdown of how the 7.9 secs 
> are spent
> would be very interesting.  By time, by SQL statement (if all the 
> same) and by
> data transmitted (bandwidth).  This type of profiling is really useful!
>
> /mrg
>
> On Jul 10, 2007, at 19:06, Shilen Patel wrote:
>
> > Over 2000 SELECT statements were also executed that in total took 
> > 7.90 seconds.  The top three queries in terms of execution time and 
> > invocation count are the following:

SQL Statement,Time (ms),Invocation Count
"select hibernatem0_.id as id, hibernatem0_.member_uuid as member_u2_, 
hibernatem0_.subject_id as subject_id, hibernatem0_.subject_source as 
subject_4_, hibernatem0_.subject_type as subject_5_ from grouper_members 
hibernatem0_ where (hibernatem0_.subject_id=? 
)and(hibernatem0_.subject_source=? )and(hibernatem0_.subject_type=? 
)","1,871",672
"select hibernatem0_.id as id, hibernatem0_.owner_id as owner_id, 
hibernatem0_.member_id as member_id, hibernatem0_.list_name as list_name, 
hibernatem0_.list_type as list_type, hibernatem0_.mship_type as mship_type, 
hibernatem0_.via_id as via_id, hibernatem0_.depth as depth, 
hibernatem0_.parent_membership as parent_m9_, hibernatem0_.membership_uuid as 
members10_, hibernatem0_.creator_id as creator_id, hibernatem0_.create_time 
as create_12_ from grouper_memberships hibernatem0_ where 
(hibernatem0_.owner_id=? )and(hibernatem0_.member_id=? 
)and(hibernatem0_.list_name=? )and(hibernatem0_.list_type=? )","1,531",352
"select hibernateg0_.id as id, hibernateg0_.uuid as uuid, 
hibernateg0_.parent_stem as parent_s3_, hibernateg0_.creator_id as 
creator_id, hibernateg0_.create_time as create_t5_, hibernateg0_.modifier_id 
as modifier6_, hibernateg0_.modify_time as modify_t7_, 
hibernateg0_.create_source as create_s8_, hibernateg0_.modify_source as 
modify_s9_ from grouper_groups hibernateg0_ where (hibernateg0_.uuid=? 
)",906,210
"select hibernatea0_.id as x0_0_ from grouper_attributes hibernatea0_ where 
(hibernatea0_.group_id=? )",656,70
"select hibernates0_.id as id, hibernates0_.uuid as uuid, 
hibernates0_.parent_stem as parent_s3_, hibernates0_.name as name, 
hibernates0_.display_name as display_5_, hibernates0_.creator_id as 
creator_id, hibernates0_.create_time as create_t7_, hibernates0_.modifier_id 
as modifier8_, hibernates0_.modify_time as modify_t9_, 
hibernates0_.display_extension as display10_, hibernates0_.extension as 
extension, hibernates0_.description as descrip12_, hibernates0_.create_source 
as create_13_, hibernates0_.modify_source as modify_14_ from grouper_stems 
hibernates0_ where (hibernates0_.uuid=? )",573,176
"select hibernatem0_.id as id, hibernatem0_.owner_id as owner_id, 
hibernatem0_.member_id as member_id, hibernatem0_.list_name as list_name, 
hibernatem0_.list_type as list_type, hibernatem0_.mship_type as mship_type, 
hibernatem0_.via_id as via_id, hibernatem0_.depth as depth, 
hibernatem0_.parent_membership as parent_m9_, hibernatem0_.membership_uuid as 
members10_, hibernatem0_.creator_id as creator_id, hibernatem0_.create_time 
as create_12_ from grouper_memberships hibernatem0_ where 
(hibernatem0_.member_id=? )and(hibernatem0_.list_name=? 
)and(hibernatem0_.list_type=? )",540,168
"select hibernateg0_.id as x0_0_ from grouper_groups_types hibernateg0_ where 
(hibernateg0_.group_uuid=? )",420,28
"select hibernatea0_.id as id, hibernatea0_.group_id as group_id, 
hibernatea0_.field_name as field_name, hibernatea0_.value as value from 
grouper_attributes hibernatea0_ where (hibernatea0_.field_name='name' 
)and(hibernatea0_.value=? )",250,96
"select hibernatea0_.id as id0_, hibernatea0_.group_id as group_id0_, 
hibernatea0_.field_name as field_name0_, hibernatea0_.value as value0_ from 
grouper_attributes hibernatea0_ where hibernatea0_.id=?",225,112
"select hibernateg0_.id as id, hibernateg0_.uuid as uuid, 
hibernateg0_.parent_stem as parent_s3_, hibernateg0_.creator_id as 
creator_id, hibernateg0_.create_time as create_t5_, hibernateg0_.modifier_id 
as modifier6_, hibernateg0_.modify_time as modify_t7_, 
hibernateg0_.create_source as create_s8_, hibernateg0_.modify_source as 
modify_s9_ from grouper_groups hibernateg0_ where (hibernateg0_.parent_stem=? 
)",223,14
"select hibernates0_.id as id, hibernates0_.uuid as uuid, 
hibernates0_.parent_stem as parent_s3_, hibernates0_.name as name, 
hibernates0_.display_name as display_5_, hibernates0_.creator_id as 
creator_id, hibernates0_.create_time as create_t7_, hibernates0_.modifier_id 
as modifier8_, hibernates0_.modify_time as modify_t9_, 
hibernates0_.display_extension as display10_, hibernates0_.extension as 
extension, hibernates0_.description as descrip12_, hibernates0_.create_source 
as create_13_, hibernates0_.modify_source as modify_14_ from grouper_stems 
hibernates0_ where (hibernates0_.parent_stem=? )",207,14
"select hibernateg0_.id as id, hibernateg0_.type_uuid as type_uuid, 
hibernateg0_.name as name, hibernateg0_.creator_uuid as creator_4_, 
hibernateg0_.create_time as create_t5_, hibernateg0_.is_assignable as 
is_assig6_, hibernateg0_.is_internal as is_inter7_ from grouper_types 
hibernateg0_ where (hibernateg0_.type_uuid=? )",116,28
"select hibernatef0_.id as x0_0_ from grouper_fields hibernatef0_ where 
(hibernatef0_.grouptype_uuid=? ) order by hibernatef0_.name asc",105,34
"select hibernatec0_.id as id, hibernatec0_.uuid as uuid, hibernatec0_.owner 
as owner, hibernatec0_.left_factor as left_fac4_, hibernatec0_.right_factor 
as right_fa5_, hibernatec0_.type as type, hibernatec0_.creator_id as 
creator_id, hibernatec0_.create_time as create_t8_ from grouper_composites 
hibernatec0_ where (hibernatec0_.owner=? )",102,28
"select hibernateg0_.id as id0_, hibernateg0_.group_uuid as group_uuid0_, 
hibernateg0_.type_uuid as type_uuid0_ from grouper_groups_types hibernateg0_ 
where hibernateg0_.id=?",84,28
"select hibernates0_.id as id, hibernates0_.uuid as uuid, 
hibernates0_.parent_stem as parent_s3_, hibernates0_.name as name, 
hibernates0_.display_name as display_5_, hibernates0_.creator_id as 
creator_id, hibernates0_.create_time as create_t7_, hibernates0_.modifier_id 
as modifier8_, hibernates0_.modify_time as modify_t9_, 
hibernates0_.display_extension as display10_, hibernates0_.extension as 
extension, hibernates0_.description as descrip12_, hibernates0_.create_source 
as create_13_, hibernates0_.modify_source as modify_14_ from grouper_stems 
hibernates0_ where (hibernates0_.name=? )",58,40
"select hibernatef0_.id as id, hibernatef0_.field_uuid as field_uuid, 
hibernatef0_.grouptype_uuid as grouptyp3_, hibernatef0_.is_nullable as 
is_nulla4_, hibernatef0_.name as name, hibernatef0_.read_privilege as 
read_pri6_, hibernatef0_.type as type, hibernatef0_.write_privilege as 
write_pr8_ from grouper_fields hibernatef0_ where (type=? ) order by name 
asc",23,2
"select hibernateg0_.id as id, hibernateg0_.type_uuid as type_uuid, 
hibernateg0_.name as name, hibernateg0_.creator_uuid as creator_4_, 
hibernateg0_.create_time as create_t5_, hibernateg0_.is_assignable as 
is_assig6_, hibernateg0_.is_internal as is_inter7_ from grouper_types 
hibernateg0_ order by name asc",4,2
"select hibernatef0_.id as id, hibernatef0_.field_uuid as field_uuid, 
hibernatef0_.grouptype_uuid as grouptyp3_, hibernatef0_.is_nullable as 
is_nulla4_, hibernatef0_.name as name, hibernatef0_.read_privilege as 
read_pri6_, hibernatef0_.type as type, hibernatef0_.write_privilege as 
write_pr8_ from grouper_fields hibernatef0_ order by name asc",2,2