Forum OpenACS Development: cc_users vs. acs_users_all

Collapse
1: cc_users vs. acs_users_all
Posted by Malte Sussdorff on 03/13/04 02:59 PM
I detected that acs_users_all is faster by a magnitude of 2-3 than cc_users if dealing with 180K users.

It would be nice for scalability reasons to use acs_users_all instead of cc_users if possible. I made a change already on the 5-0 branch, hope it comes into 5-1, otherwise I can commit it there as well (for login of the user. Should not take 15 seconds).

Collapse
2: Re: cc_users vs. acs_users_all (response to 1)
Posted by Don Baccus on 03/13/04 04:11 PM
It would be nice if they returned the same thing, but they don't,  deleted users will be returned in that view as well as user 0.

Please don't put this change into the FROZEN except major bug fixes 5.1, much less 5.0.  There could be hidden and embarrassing consequences.

Collapse
3: Re: cc_users vs. acs_users_all (response to 2)
Posted by Malte Sussdorff on 03/13/04 05:59 PM
So I assume we are stuck with cc_users and util_memoize? Isn't there a faster way to retrieve the user_id from an email or a screenname than querying cc_users ?
Collapse
4: Re: cc_users vs. acs_users_all (response to 1)
Posted by Don Baccus on 03/14/04 04:15 AM
Is this Postgres or Oracle?  Can you post the execution plan for the query using cc_users on your 180K users?