Forum .LRN Q&A: Re: .LRN v2 Performance
Now our database is empty and we can't test it, sorry.
The problems the scalability detected with 40.000 users are because the table acs_permissions have 500.000 of rows.
The first of otcubre will have the 15.000 users loaded in the database and then we will make yield tests.
University of Valencia
select count(*) from acs_permissions;
and getting this speed:
132 ms 0or1row dbqd.acs-tcl.tcl.acs-permissions-procs.permission::permission_p_not_cached.select_permission_p: 0or1row nsdb0
select 1 from dual
( select 1
from acs_object_party_privilege_map ppm
where ppm.object_id = '1228' and ppm.party_id = '16319' and ppm.privilege = 'dotlrn_browse' )
As you see, the permission call has been changed lately, with 500K entries on acs_permissions you should be fine I think (though it can still be improved), specially since your db server if bigger than ours.