topic Re: Best performance searching node in Alfresco Archive

Best performance searching node

spilby — Tue, 22 Apr 2014 14:11:28 GMT

Hi,I need to search a node in my Alfresco repository, with the Alfresco Java API. I have a initial path where I must begin to search, and a property value to find.My repository will be big, because of this, I need the search quick and efficient.There are various methods to implement this search. For

Re: Best performance searching node

mitpatoliya — Tue, 22 Apr 2014 17:57:58 GMT

This should work efficiently for you.
getSearchService().query(WORKSPACE_SPACESSTORE, SearchService.LANGUAGE_LUCENE, query);

But main performance will be depend your query.If you combine path query and property queries it will give good performance.

Re: Best performance searching node

romschn — Tue, 22 Apr 2014 18:55:00 GMT

As per my knowledge, PATH queries are slow when it comes to performance. You may want to use TYPE query with properties it would be fast compare to PATH queries if you do not want explicitly search from some specific PATH.

Re: Best performance searching node

mitpatoliya — Wed, 23 Apr 2014 06:06:50 GMT

Yes, I do agree with Ramesh, TYPE queries are faster then PATH queries.
Provided you do not have idea within which path your contents are stores(which you seems to have in this case as you have mentioned) and if you want to search content of only certain type.

Re: Best performance searching node

spilby — Wed, 23 Apr 2014 06:55:00 GMT

Thanks for all the answers! ) My query is more or less this:

PATH: "/app:company_home/app:user_homes/cm:rootFolder/cm:folder2" AND @exp\:exposition_number:"123" AND TYPE: "{project.size.model}margin"

I have an initial path from which begin to search (before the search, I know if it begins from folder1, folder2, …, or folderN, where N is 500). The tree of subfolders are pretty big, thousand of subfolders from each of these N folders.

My query combines a PATH (I imagine is better to include, although TYPE is faster, to discard primary folders in which I don't need to search), a TYPE and a own property exposition_number.

You see it ok? The order of the elements in the query (PATH, property and TYPE) is important for the performance?

Thanks again!

Re: Best performance searching node

spilby — Tue, 29 Apr 2014 06:32:10 GMT

Any suggerence about this problem, please?

Re: Best performance searching node

mrogers — Tue, 29 Apr 2014 08:31:58 GMT

Search is an area of considerable change at the moment. Has been for the last couple of releases and will be for the next few. That will mean there's a possibility of one approach "leapfrogging" another.

However you need to target a particular version so I suggest you just benchmark each approach and see what's best.