Hi!
In the University of Valencia we are updated the .LRN 2.0.1 to .LRN
2.0.2 with 40.000 users and 200 classes.
Now, when we go to "My Space" the system takes 6 sg. in showing the page
We are actived the Developer Support and the problem this in the function acs-permissions-cretae.sql
Somebody can help us.
--------Information by Developer Support---------------
4389 ms dbqd.dotlrn.www.dotlrn-main-
portlet.select_communities: select nsdb0
select dotlrn_communities_all.*,
dotlrn_community__url
(dotlrn_communities_all.community_id) as url,
(CASE
WHEN
dotlrn_communities_all.community_type
= 'dotlrn_community'
THEN 'dotlrn_community'
WHEN dotlrn_communities_all.community_type
= 'dotlrn_club'
THEN 'dotlrn_club'
ELSE 'dotlrn_class_instance'
END) as simple_community_type,
tree_level(dotlrn_communities_all.tree_sortkey) as
tree_level,
coalesce((select tree_level
(dotlrn_community_types.tree_sortkey)
from dotlrn_community_types
where dotlrn_community_types.community_type =
dotlrn_communities_all.community_type), 0) as community_type_level,
acs_permission__permission_p
(dotlrn_communities_all.community_id, '3045612', 'admin') as admin_p
from dotlrn_communities_all,
dotlrn_member_rels_approved
where dotlrn_communities_all.community_id =
dotlrn_member_rels_approved.community_id
and dotlrn_member_rels_approved.user_id = '3045612'
order by dotlrn_communities_all.tree_sortkey
