topic Low Performance when executing search method in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/low-performance-when-executing-search-method/m-p/177887#M131017 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I'm running a script as an action that does the following:</SPAN><BR /><BR /><SPAN>1. Reads a bunch of records from an Excel File</SPAN><BR /><SPAN>2. Looks up for a space within the repository using. Here's the code snippet:</SPAN><BR /><BR /><SPAN>var query = "@cm\\:name:\""+number+"\" AND TYPE:cm\\:folder AND PATH:\""+path+"//*\"";</SPAN><BR /><SPAN>var docs = search.luceneSearch(query);</SPAN><BR /><BR /><SPAN>3. Assigns metadata values to an aspect using the data taken from the Excel file</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Here's some information about the repository and the platform it was deployed on:</SPAN><BR /><BR /><SPAN>- Server: Processor 2.6 Ghz ; 4 GB RAM</SPAN><BR /><SPAN>- Win 2003 Server</SPAN><BR /><SPAN>- Database PostgreSQL 8.3</SPAN><BR /><SPAN>- Alfresco Community 2.1</SPAN><BR /><BR /><SPAN>We just tested the queries on the Postgre admin console and they seem to be running all right.</SPAN><BR /><BR /><SPAN>Any hints on where the bottleneck of this may be?</SPAN><BR /><BR /><SPAN>Thanks in advance,</SPAN><BR /><STRONG>Esteban</STRONG></BODY></HTML> Mon, 22 Sep 2008 19:55:42 GMT ediez 2008-09-22T19:55:42Z Low Performance when executing search method https://connect.hyland.com/t5/alfresco-archive/low-performance-when-executing-search-method/m-p/177887#M131017 Hi,I'm running a script as an action that does the following:1. Reads a bunch of records from an Excel File2. 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 Mon, 22 Sep 2008 19:55:42 GMT https://connect.hyland.com/t5/alfresco-archive/low-performance-when-executing-search-method/m-p/177887#M131017 ediez 2008-09-22T19:55:42Z Re: Low Performance when executing search method https://connect.hyland.com/t5/alfresco-archive/low-performance-when-executing-search-method/m-p/177888#M131018 <HTML><HEAD></HEAD><BODY><SPAN>Hi to all,</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Has anyone got a hint on this?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN></BODY></HTML> Wed, 24 Sep 2008 03:15:56 GMT https://connect.hyland.com/t5/alfresco-archive/low-performance-when-executing-search-method/m-p/177888#M131018 ediez 2008-09-24T03:15:56Z