Forum .LRN Q&A: Re: .LRN v2 Performance

Collapse
28: Re: .LRN v2 Performance (response to 1)
Posted by Nima Mazloumi on
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