Hello,
Maybe some one migrated to SQL DB and faced similar issues.
We migrated our test environment and it performs very slow comparing to Oracle DBs.
We think, that main issue is two SQL queries, they takes long time to produce:
1. select internalgr1_.id as id1_33_, internalgr1_.group_name as group_na2_33_, internalgr1_.lower_group_name as lower_gr3_33_, internalgr1_.active as active4_33_, internalgr1_.local as local5_33_, internalgr1_.created_date as created_6_33_, internalgr1_.updated_date as updated_7_33_, internalgr1_.description as descript8_33_, internalgr1_.group_type as group_ty9_33_, internalgr1_.directory_id as directo10_33_, internalgr1_.external_id as externa11_33_ from cwd_membership hibernatem0_ inner join cwd_group internalgr1_ on hibernatem0_.parent_id=internalgr1_.id cross join cwd_user internalus2_ where hibernatem0_.child_user_id=internalus2_.id and (internalus2_.lower_user_name in ( @P0 )) and internalgr1_.directory_id= @P1 order by internalgr1_.lower_group_name
2. select contentent0_.CONTENTID as col_0_0_, contentent0_.VERSION as col_1_0_, contentent0_.LASTMODDATE as col_2_0_, contentent0_.VERSIONCOMMENT as col_3_0_, contentent0_.LASTMODIFIER as col_4_0_, user2conte1_.SOURCEUSER as col_5_0_ from CONTENT contentent0_ cross join USERCONTENT_RELATION user2conte1_ inner join user_mapping confluence3_ on user2conte1_.SOURCEUSER=confluence3_.user_key inner join user_mapping confluence2_ on contentent0_.LASTMODIFIER=confluence2_.user_key where (contentent0_.PREVVER= @P0 or contentent0_.CONTENTID= @P1 ) and contentent0_.CONTENT_STATUS='current' and contentent0_.CONTENTID=user2conte1_.TARGETCONTENTID and user2conte1_.RELATIONNAME='collaborator' order by contentent0_.VERSION desc
If we are going to do the performance tuning (adding/removing indexes). Does those changes will be override by new Confluence version?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.