topic Re: Slow Search Response with multiple categories in Alfresco Archive

Slow Search Response with multiple categories

stevewickii — Tue, 22 Jan 2008 21:10:07 GMT

We are performing a pretty simple search.We have a web application on a separate server that uses the Alfresco webservice client api to query alfresco on another physical server. We want all documents in a folder that match any of a number of categories.Here's my query:+PATH:"/app:company_home/cm:F

Re: Slow Search Response with multiple categories

hbf — Thu, 03 Apr 2008 19:03:49 GMT

Have you found out a way to speed up your category searches?

I am performing simpler queries but I need the result for AJAX responses and for this, it should really be fast. I am in the range of 0.5 second and would like to have something much faster.

Maybe an Alfresco engineer can help us with a trick? Maybe an appropriate ehcache or Lucene configuration will help?

Thanks in advance,
Kaspar

Re: Slow Search Response with multiple categories

stevewickii — Fri, 25 Apr 2008 18:46:22 GMT

Well, Alfresco 2.9.0C_dev is available now, and I still don't see an improvement querying by Categories.

What we did to improve speed was convert each category to a NodeRef, and then query for Document Nodes where the categories property contains the NodeRef we're looking for.

+PARENT:"workspace://SpacesStore/6f9c8d63-7069-11dc-9c51-a36d884e565a" 
+(@cm\:categories:"workspace://SpacesStore/bd7e3f09-3616-11dc-a7d0-67d533e7244b"
OR @cm\:categories:"workspace://SpacesStore/a39d7d01-7103-11dc-9a14-ed64e29c2348")
-TYPE:"cm:folder"
‍‍‍‍‍

Here the PARENT NodeRef is for a Folder Node, and each categories NodeRef is for a Category Node. This query yeilds results much faster than a query by PATH. There is one issue. After we upgraded alfresco from v2.1.0 to 2.9.0B, querying by the categories property stopped working! To resolve this issue we had to delete and restore all of the documents in alfresco.