topic Perform count(*) with Lucene's query in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/perform-count-with-lucene-s-query/m-p/290878#M244008 <HTML><HEAD></HEAD><BODY><SPAN>Hi guys,</SPAN><BR /><SPAN>I'm facing with a hard job to do. I have to COUNT all the documents that match a specific query. The number of matching documents is around 100'000. My searchparameter is composed in this way:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SearchParameters sp = new SearchParameters();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.addStore(Repository.getStoreRef());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.setLanguage(SearchService.LANGUAGE_LUCENE);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.setQuery(finalQuery);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.setMaxPermissionChecks(600*1000);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.setMaxPermissionCheckTimeMillis(600*1000);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.setLimitBy(LimitBy.UNLIMITED);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.setLimit(0);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.setMaxItems(-1);<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>This kind of query takes about 600000 ms to finish !!!(sometimes this time is not enough and resultset is incomplete <img id="smileyindifferent" class="emoticon emoticon-smileyindifferent" src="https://connect.hyland.com/i/smilies/16x16_smiley-indifferent.png" alt="Smiley Indifferent" title="Smiley Indifferent" />). At the end of query i get resultset.length value. I'm using java-backend webscript to do this task. Are there other ways to go to reach the goal???</SPAN><BR /><BR /><SPAN>I'm groping into darkness…</SPAN><BR /><BR /><SPAN>thanks.</SPAN><BR /><SPAN>a.&nbsp;&nbsp;&nbsp;</SPAN></BODY></HTML> Thu, 20 Jun 2013 15:44:37 GMT alf_kin 2013-06-20T15:44:37Z Perform count(*) with Lucene's query https://connect.hyland.com/t5/alfresco-archive/perform-count-with-lucene-s-query/m-p/290878#M244008 Hi guys,I'm facing with a hard job to do. I have to COUNT all the documents that match a specific query. The number of matching documents is around 100'000. My searchparameter is composed in this way:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SearchParameters sp = new SearchParameters();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp.addStore(Repository.getStoreRe Thu, 20 Jun 2013 15:44:37 GMT https://connect.hyland.com/t5/alfresco-archive/perform-count-with-lucene-s-query/m-p/290878#M244008 alf_kin 2013-06-20T15:44:37Z Re: Perform count(*) with Lucene's query https://connect.hyland.com/t5/alfresco-archive/perform-count-with-lucene-s-query/m-p/290879#M244009 <HTML><HEAD></HEAD><BODY><SPAN>Googling i have found this snipset</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />TopScoreDocCollector collector = TopScoreDocCollector.create(10, true);<BR />searcher.search(query, collector);<BR />TopDocs topDocs = collector.topDocs();<BR />int numResults = collector.getTotalHits();<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>which should enable me to count document whitout take all documents informations. But now the question is: can i use pure lucene-api in Alfresco webscript??</SPAN></BODY></HTML> Thu, 20 Jun 2013 16:16:23 GMT https://connect.hyland.com/t5/alfresco-archive/perform-count-with-lucene-s-query/m-p/290879#M244009 alf_kin 2013-06-20T16:16:23Z