The directory package has a view:
create view dir_all_users as
select p.party_id as user_id, p.email, pe.first_names, pe.last_name, p.url
from parties p, persons pe
where p.party_id = pe.person_id;
replaced by all_users now in acs-kernal
There is a view cc_users in acs-kernel which provides this basic info, plus much more, but is signifigantly slower.
Would it be a good idea to move this view into the core of OpenACS and fix directory to use this more general view?
Obviously some applications will not be able to take advantage of this simpler view, but where it can be used there is a performance advantage.