Low Performance when executing search method

[ediez]

Hi,

I'm running a script as an action that does the following:

1. Reads a bunch of records from an Excel File
2. Looks up for a space within the repository using. Here's the code snippet:

var query = "@cm\\:name:\""+number+"\" AND TYPE:cm\\:folder AND PATH:\""+path+"//*\"";
var docs = search.luceneSearch(query);

3. Assigns metadata values to an aspect using the data taken from the Excel file

Our issue is that the command that searches within the repository (var docs = search.luceneSearch(query):smileywink: is taking an average of 1.8 Minutes (on each iteration) to be executed. That looks like way too much time for just a query.

Here's some information about the repository and the platform it was deployed on:

- Server: Processor 2.6 Ghz ; 4 GB RAM
- Win 2003 Server
- Database PostgreSQL 8.3
- Alfresco Community 2.1

We just tested the queries on the Postgre admin console and they seem to be running all right.

Any hints on where the bottleneck of this may be?

Thanks in advance,
Esteban

[ediez]

Hi to all,

I've been looking deeper into this issue and found out that the problem might be with Lucene indexes, as I ran the queries on the Postgree admin console and they are executed normally.

Has anyone got a hint on this?

Thanks,