topic Re: Web Scripts executing slowly in Alfresco Archive

Web Scripts executing slowly

eagledelta1 — Mon, 30 Jul 2012 16:16:53 GMT

Hi, I am currently working on moving our alfresco server from a local Ubuntu VM to a RHEL5 VM at our datacenter.So far everything has worked great, except for one script that execute when metadata is added to a document in a specific folder. This script:var descT = '';var fieldA = ['Onum','PO'];for

Re: Web Scripts executing slowly

eagledelta1 — Tue, 31 Jul 2012 17:53:24 GMT

Is there no one with any sort of answer, suggestion or even question?

Re: Web Scripts executing slowly

afaust — Wed, 01 Aug 2012 07:51:59 GMT

Hello,

you should keep in mind that Lucene PATH queries, especially one for "..//*", can take a very long time depending on the state, content and I/O performance of the index. Until there is more information, I'd bet on this as my most-likely suspect, since you perform this type of search in a loop none the less.

I'd suggest adding some logging to your web script in order to measure what individual part of it executes slowly. So, you should at least put some simple log statements at the begin and end of your loop, and before / after you execute the search.

Regards
Axel

Re: Web Scripts executing slowly

mrogers — Wed, 01 Aug 2012 08:56:24 GMT

It may also be worth you experimenting with removing that path statement - or do you have other sites containing kb:referenceable?

Another approach is to use 4.0 and SOLR which doesn't have the problems with paths.