Hi all,
I've been working on the dotlrn/www/members page in the last couple of days.
For 835 rows in the multirow the page took 60 sec to display (6 sec database and 51 sec page rendering).
So I moved to
- list builder --> 30 sec less
- changed the line
set member_url [acs_community_member_url -user_id $user_id]
to
set member_url "[dotlrn::get_url]/community-member?user_id=$user_id"
--> 21 sec less
So right now the page is rendered in 9 sec.
The database call to get all current members takes 900 ms while the database call to add the list of supergroup members in case of subgroups takes 5 sec. So next is to improve that query. The other option would be to split that page in two pages - one for current and one for possible members.
The current members page would then take 2 sec to render while the other would take 7 sec.
Please test the above and check if it breaks anything.
Greetings,
Nima