Forum OpenACS Development: Re: Scalability of acs_objects and acs_object_context_index

Collapse
34: Re: Scalability of acs_objects and acs_object_context_index (response to 1)
Posted by Barry Books on 05/14/03 12:41 AM
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
Collapse
35: Re: Scalability of acs_objects and acs_object_context_index (response to 34)
Posted by Tilmann Singer on 05/14/03 01:03 AM
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.