Performance issue in fetching noderefs from resultset.

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.

faizaan

Hi,

I am facing performance issue in fetching noderefs from lucene resultset for 5 concurrent users, w.r.t below code snippet line that executes lucene query " resultSet = AlfrescoServiceRegistry.getSearchService().query(searchParameters)" is taking only  1-2 sec to execute but line that fetches noderefs from resultset "listNodeRefs = resultSet.getNodeRefs()" is taking around 25-30 sec, I am fetching only 25 records into resultset for pagination out total 1000-1500 records.

Please suggest how can we bring down execution time for this method.

Environment :  Alfresco 3.4.3 EE, MYSQL, Tomcat.

    public static List<NodeRef> executeSPQuery(final String query, final String siteName, final String pageSize, final String skipCount, final String sortField,
            final String sortOrder)
    {
        ResultSet resultSet = null;
        List<NodeRef> listNodeRefs = null;
        try
        {
            // For sorting and limit the result , uses searchparameters
            final SearchParameters searchParameters = new SearchParameters();
            searchParameters.addStore(Repository.getStoreRef());
            searchParameters.setLanguage(SearchService.LANGUAGE_LUCENE);
            searchParameters.setQuery(query);
            searchParameters.setMaxItems(Integer.parseInt(pageSize));
            searchParameters.setSkipCount(Integer.parseInt(skipCount));

            searchParameters.addSort(SearchParameters.SORT_IN_DOCUMENT_ORDER_DESCENDING);
              
            LOGGER.debug("==========Started Executing Query=======");
            
            resultSet = AlfrescoServiceRegistry.getSearchService().query(searchParameters);
            
            LOGGER.debug("==========Completed Executing Query=======");

            if (resultSet != null && resultSet.length() > 0)
            {
               LOGGER.debug("====Started Getting noderefs=======");
               
               resultSet.setBulkFetch(true);
               resultSet.setBulkFetchSize(10000);
               
               LOGGER.debug(">>>>>>>Result set size : "+resultSet.length());
               
                listNodeRefs = resultSet.getNodeRefs();
                
                LOGGER.debug("====Completed Getting noderefs=======");
            }

        }
         catch (final LuceneQueryParserException e)
        {
            LOGGER.info("Problem in Parsing the Lucene query :: " + query, e);
            return listNodeRefs;
        } 
        catch (final Exception e)
        {
            LOGGER.info("Problem in Parsing the Lucene query :: " + query, e);
            return listNodeRefs;
        } 
        finally
        {
            if (resultSet != null)
            {
                resultSet.close();
                resultSet = null;
            }
        }

        return listNodeRefs;
    }
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks,
Faizaan

faizaan

Fixed this by setting bulkfetch size equal to page size, this brought execution time of method from around 25-30 sec to 4-5 sec for 5 concurrent users.

                resultSet.setBulkFetch(true);
               resultSet.setBulkFetchSize(Integer.parseInt(pageSize));
               
                listNodeRefs = resultSet.getNodeRefs();
                
‍‍‍‍‍‍‍‍

Thanks !
Faizaan