[Building Sakai] Proposed API change to reduce cost of resources list view

[R.P. Aditya]

On 2009-09-22, Jim Eng <jimeng at umich.edu> wrote:
> there are other variations) for which there are entries in the  
> sakai_realm_rl_fn table where the role_key identifies the anonymous  
> role and the function_key corresponds to "content.read". The result  
> would be a list of realm identifiers.

I haven't run the stats yet but I'd suspect that *most* resources are
not public. If that is the case, then having a separate table to just
list the public resources will likely be your best bet, esp. if it is
going to be consulted so often.

Your updated api call could then see if that table exists and if not,
revert to using your suggested method with the like.

Adi