Forum OpenACS Development: Re: OpenACS Permissions System - Performance Improvement Work

Rocael, why do we need the "select 1 from dual where exists". Maybe I'm just too blind to see the difference.

actually, I think is the same at least in pg, I just c/p from permission::permission_p_not_cached.select_permission_p, and guess that the "dual" part was still there because it came from previous ways when the acs_object_party_privilege_map wan't available yet and the dual use was needed.