Forum OpenACS Development: Re: Scalability of acs_objects and acs_object_context_index

Try it without any permission check and see what the results are. I suspect acs_object.name and site_node.url are as much a problem (if not more) than the permission call
Dirk, is there any specific reason why you are always including site_node.url in the queries you are testing? I thought that was discussed previously and it was agreed that this proc could be replaced in most cases. I would be more interested in stats that measure realistic security checks only, which are required in many situations.