nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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

Find more posts tagged with

Comments

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