We have a repository with about 2M documents.
We are trying to get list of documents that have a certain category (attribute) assigned.
I am using CMIS Workbench to connect to Alfresco 18.104.22.168
Each time I ran the simple select query I get different result set.
Attempt 1: 3185 results, 107 seconds
Attempt 2: 3065 results, 93 seconds
Attempt 3: 4197 results, 112 seconds
Attempt 4: 3003 results, 76 seconds
We should have close to 100K documents that fall within the category we are searching for.