topic Re: Alfresco full-text search slow? in Alfresco Archive

Alfresco full-text search slow?

warrenzhai — Thu, 25 May 2006 20:46:47 GMT

I uploaded 2GB of data to Alfresco. A full-text search could take up to 2 minutes. I am wondering what I can do to optimize performance. Anyone else has a similar problem?

Re: Alfresco full-text search slow?

steve — Fri, 26 May 2006 08:38:43 GMT

Hello,

Your timings for full text search do sound very high.

We have had repo with 2 million content items and the full text search returns results in under 10 seconds for a well constrained search - obviously if you search for something that returns 1 million matches then you are going to see that time go up a bit

Could you give us some details on the machine you are running Alfresco on, and the version of Alfresco you are running please?

Thanks,

Steve

Re: Alfresco full-text search slow?

andy — Tue, 30 May 2006 11:04:09 GMT

Hi

Can you let us know the version of Alfresco version you are using?
Is this search as a regular user?
How are you doing the search?
What is the search string?

Try limiting the number of results returned by the query.
This is done in the UI search and available on the search API.

This will reduce the number of underlying operations (like access checks) on nodes you will never display - just to see how many things you would find.

I suspect you are finding all or nearly all docs and doing access checks on all of them.

Regards

Andy

Re: Alfresco full-text search slow?

warrenzhai — Wed, 07 Jun 2006 21:45:47 GMT

I am trying for Alfresco usage in my company. I think the problem has to do with overly generalized search patterns that some of our test users actually use.

Many users are used to the quick response they get from Google. They expect to type something like "Blah" and get almost instant response from Alfresco. Alfresco generally takes more time when the search pattern is very short. Is there any possibility to return the first page or two of hits very quickly and compile the complete resultset later?