Response time for heavy query

[itayh]

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 took about 15 minutes per query. I notice that during this period there are times when no queries running on DB and no CPU usage. Its look like it is waiting for something.

I am using alfresco 2.1.

Any Idea's?

Thx

[mark_smithson]

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.

[rwetherall]

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

[itayh]

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

[kevinr]

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

Thanks,

Kevin

[itayh]

Hi,

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

Thx

[kevinr]

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

[itayh]

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

[rwetherall]

Hi,

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

Cheers,
Roy