Forum OpenACS Development: Response to ACS 4.x won't scale (I hope I am wrong)

Collapse
Posted by Henry Minsky on
To follow up Tom Jackson's comment, the only information
that the system is implemented to answer efficiently is a yes/no question - so doing
a SELECT * from those views and getting combinatorial numbers of
rows is not really unexpected.  You are in effect asking for the relations of everything to everything. If you really do want to actually enumerate
a specific set of permissions (i.e., you really do want a list
of all users authorized to view object X), you ought to query the data model more
directly.