Search must performed 2 times to get the complete list

[wmay]

I have the problem that i often have to search 2 times to get the complete result list - the first time when i perform the search - only a quick search using a single word which should bring back a longer result list e.g. 200 document hits.

When i search the first time i get only a single document as result and then when i perform the search a second time i get the full and i would say correct search result list with all documents. This happens only when the search result is a longer list of documents.

When i then do this search again and again with the same search criteria - the result is allways ok and also faster then the first time - so it seems to be cached. But when i try a new word which also should bring back a longer hit list - very often the same happens - first search - no result or only one document and then the second try the complete list.

It seems that there is a timeout and the seach or fill the result list is cancled and then in the background the old search is cache and so when i try this search a second time it is in the cache and i get the full list.

There is no "error" message or something else to inform the customer - what happens - this is a problem which makes the user uncertain because he knows that there are multiple results but they do not come up and when he tries it a second time the result is different like before.

Is there any parameter and setting what can be changed or tuned so that this does not happens and that all the complete or the same result list comes up with each search ?

Thank you for your help and comments.

[mrogers]

Yes there is a timeout for the query, it sounds like the first run is finding so much information and ubsequent queries find more.

How are you calling search ?

[wmay]

My tests shows that this is a problem which comes up with the normal alfresco explorer and also with share. I used the quick search - all items - e.f. i search for "atom" it takes 20 or 30 sec. to get a result - this result is a single document, then when i perform the same search again i get "all" results - 56 pages in the alfresco explorer - there are for sure more documents with as his but i think there exists a limit and not all documents comes back. Same happens with Share search. The result of the second search comes back within less than a second. From this time on when the first time all results are found - it is fast and with each search using the criteria like before brings back "all" documents - so it seesm that this result or search is now cached. When i do this with an other word - the same happens again.

I have 250.000 documents, all PDF, the information i searched is not in the document content text but only in the filename of the documents. Tested with 3.4d, My-SQL, MS-Windows 2008 Server, 6-8GB RAM, 2-4 cores

Why this can happen - this confuses each user that one search performed 2 times brings back one time one result document and then 56 pages ? without a warning or any other information that there was a time-out or something like this.

Strange is also that when i immediately press search again the complete result comes up correct. Why this can not be with the first try ?

first search result: http://www.may.co.at/webrr/respfile.php?file=MAYComp/Current/RO/first_search.png
second search result: http://www.may.co.at/webrr/respfile.php?file=MAYComp/Current/RO/second_search.png

[mrogers]

These are the two properties to change.

system.acl.maxPermissionCheckTimeMillis=10000
system.acl.maxPermissionChecks=1000

[wmay]

Are this the correct parameters which should be so so that it works or in which direction they should changed ?
Are these the default settings ?
Any recommendation what would be the optimal values for these parameters - from / to ?

[wmay]

In which file i can find them ?
Where is this file located ?

Thank you for your help

[mrogers]

Put
system.acl.maxPermissionCheckTimeMillis=30000
in your alfresco-global.properties file.

Restart alfresco.

See if that does the trick.

[wmay]

ok, i did it - first search took ~28 sek to get back a result - but the same happens - only one document found - then immediatley after a second search and the full result with 56 pages comes up.

[mrogers]

try to increase the maxPermissionChecks and see if that does the trick.

[wmay]

i changed it to 40000 and 10000 but allways the same result - no change - after 30 sek. the first result and then when performing a second search all.