Performance Alfresco Searches

[aferraro]

Hello everybody!
I have a question about Alfresco searches:

If I make a search for a document inside a single Space containing only documents and instead if a make this search for the same document  inside a Space containing other sub-spaces everyone of which containing documents, (the total number of documents contained is exactly the same in the two cases)  I have substantial differences of performance between the two searches?
how work Alfresco searches?

Thank you very much,
Antonio.

[derek]

Hi,
The difference in performance comes primarily from the increased number of permission checks required because (I presume) you are getting more documents returned by the search.  Each document that matches the search criteria has a permission evaluation done on it.  Performance is approximately proportional to the number of documents returned by your search terms.
Regards

[aferraro]

Thanks derek for your answer,

Do you know if there are substantial differences of performance between the two queries in condition of parity of document number returned by the two searches?

1. query for documents inside a Single Spase containing only documents whitout sub-spaces
2. query for documents inside a Space containing sub-spaces each one with documents inside

Thank you very much,
Antonio.

[derek]

Hi,
The actual search is not (hardly) affected by the different structures you describe.  The performance is related to the number of results returned by the search.  So, you could do a search across multiple folders that only returns a single document (before permission checks) and one that does a search across a single folder but returns 1000 documents (before permission checks).  The first one will be much faster once permission checks are applied.
Regards

[aferraro]

Thank you, derek, for your quickly responces!


So in this scenario, performance depend only on the number of documents returned by the queries.



Ciao,
Antonio.