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

Collapse
20: Re: .LRN v2 Performance (response to 1)
Posted by Dario Roig on 09/17/04 08:59 AM
Hi!

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.

Thanks.
University of Valencia

Collapse
23: Re: .LRN v2 Performance (response to 20)
Posted by Rocael Hernández Rizzardini on 09/17/04 02:57 PM
Galileo has:
select count(*) from acs_permissions;
count
--------
383347
(1 row)

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
where exists
          ( 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.