Permission and performance

[andrepra]

How the permission checking impact the performance during a search?
Suppose you have a large repository with a lot of documents (1 M). Suppose that a user has visibility on few documents (100). What happen when the user makes a generic search (ie for the category invoice) that hit 10.000 documents?
Alfresco performs the search finding the 10k documents and after check the permissions for each one or the permission checking is integrated in the lucene search?
Exists any method to estimate if the query will return a large result and will take some time?

thanks
Andrea

[andy]

Hi

Queries can be limited by size and by execution time.
If the results are limited then this is indicated on the meta data.

Regards

Andy

[andrepra]

We start to make the test in a repository of 1M and we find some problems related to performance.
I saw the configuration to limit the size of results but I didn't find any configuration about execution time. Can you help me?
thanks
Andrew

[andy]

Hi

This is in repository.properties.

#
# Properties to limit resources spent on individual searches
#
# The maximum time spent pruning results
system.acl.maxPermissionCheckTimeMillis=10000
# The maximum number of results to perform permission checks against
system.acl.maxPermissionChecks=1000
‍‍‍‍‍‍‍‍‍

If you do not see these properties then your version of Alfresco does not support this.

Regards

Andy