topic Re: Response time for heavy query in Alfresco Archive

Response time for heavy query

itayh — Sun, 05 Aug 2007 05:52:15 GMT

Hi,I uploaded 2000 spaces each space contain 1-2 contents.I am using web service API to get those contents (using lucene query).Running query to get the contents/spaces on my local host alfresco (Windows) took about 3-4 minutes per query.Running query to get the contents/spaces on our linux alfresco

Re: Response time for heavy query

mark_smithson — Sun, 05 Aug 2007 16:19:54 GMT

Hi

I have a similar problem with search performance and am about to make a post when I can decide the correct forum for it.

Having profiled it it seems to be Alfresco running ACL checks on the query results. In my situation the lucene query takes 15ms, but the ACL checks take up to 10s.

Re: Response time for heavy query

rwetherall — Mon, 06 Aug 2007 10:57:29 GMT

Hi,

The web service 'layer' in the repository only really passes on the query to the fundamental service so any performance overhead is unlikly to be the fault of the web service API as such.

Perhaps you could post an example of the queries you are experiencing slow responce times with. It may be that we can tweak the query string to improve performance.

Cheers,
Roy

Re: Response time for heavy query

itayh — Tue, 07 Aug 2007 06:28:17 GMT

Hi,

Thx for your response.

I am using the next lucene query:

"PATH:\"/app:company_home/cmevice_x0020_Management/*/*/*\" AND TYPE:\"{custom.model}DeviceVariant\""

I just need some properties for those nodes. I notice that after

QueryResult queryResult = repositoryService.query( ClientConstants.STORE, deviceVariantsQuery, false);

I get 200M as response. This is what take the time (pass 200M on soap from the server to my computer).

Is there any way to reduce the size of the response to include only the columns (properties) I am interested in an not all the objects?

Thx alot,
Itay

Re: Response time for heavy query

kevinr — Wed, 08 Aug 2007 13:40:41 GMT

I suggest you try a more specific query to filter your results to a more specific set.

Thanks,

Kevin

Re: Response time for heavy query

itayh — Wed, 08 Aug 2007 15:15:48 GMT

Hi,

Can i query just part on my content properties?
I could not see example for that.

Thx

Re: Response time for heavy query

kevinr — Mon, 13 Aug 2007 15:04:11 GMT

You can query on any attribute specifically - all attributes are indexed unless you have marked them otherwise in your model.
http://wiki.alfresco.com/wiki/Search#Finding_nodes_by_text_property_values

Thanks,

Kevin

Re: Response time for heavy query

itayh — Mon, 13 Aug 2007 16:46:28 GMT

Thank you Kevin for your response.

I was not clear enough.
What I mean is, can I run query (using the web service api) and get as result from alfresco just part of the properties and not all of them?

(The QueryResult holds to many unnecessary parameters that I don't want and don't need)

Itay

Re: Response time for heavy query

rwetherall — Wed, 15 Aug 2007 13:42:14 GMT

Hi,

Currently there is no way to change the set of columns returned by the web service search API.

Cheers,
Roy