topic Use of indexes in a query (with SOLR) in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/use-of-indexes-in-a-query-with-solr/m-p/289531#M242661 <HTML><HEAD></HEAD><BODY><SPAN>I have a doubt about how indexed properties works in Alfresco 4.1.6 with SOLR.</SPAN><BR /><BR /><SPAN>I use something like this for my queries:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />SearchParameters sp = new SearchParameters();<BR />sp.addStore(StoreRef.STORE_REF_WORKSPACE_SPACESSTORE);<BR />sp.setLanguage(SearchService.LANGUAGE_FTS_ALFRESCO);<BR />sp.setQuery(query);<BR />ResultSet results = getSearchService().query(sp);<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>where query variable is something like this:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />PATH:" /app:company_home/app:user_homes/cm:_x0030_123//*" AND ((@cm\:title:food) OR (@cm\:name:abcde) OR (TEXT:valles) OR (@doc\:custom_property:"report") OR (@doc\:custom_property2:"report") AND (@doc\:custom_property3:"report") AND TYPE:"{my.model}voc_document"<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>On my model.xml I specify what custom properties are indexed (</SPAN><PRE class="language-none line-numbers"><CODE>&lt;index enabled="true"&gt;<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>) </SPAN><BR /><BR /><SPAN>I use Alfresco 4.1.6 with SOLR. My question is… How works SOLR with the indexes if I put on the search query two or more indexed properties? Like Oracle? Oracle try the best index and use only this. Or maybe SOLR combine all the indexed properties and uses all the index on the query?&nbsp; </SPAN><BR /><BR /><SPAN>I need this answer to determine how many indexes put on my model.xml. Maybe put a lot of indexes don't give me the best and efficient result and is better index only a few properties. </SPAN><BR /><BR /><SPAN>And finally, one question… I use SearchService.LANGUAGE_FTS_ALFRESCO, but I can see that exists a earchService.LANGUAGE_SOLR_FTS_ALFRESCO. Is the same? I need to use the second if I use SOLR?</SPAN><BR /><BR /><SPAN>Thanks a lot!</SPAN><BR /><BR /><SPAN>Best regards</SPAN><BR /><BR /><BR /></BODY></HTML> Mon, 06 Jul 2015 14:01:09 GMT spilby 2015-07-06T14:01:09Z Use of indexes in a query (with SOLR) https://connect.hyland.com/t5/alfresco-archive/use-of-indexes-in-a-query-with-solr/m-p/289531#M242661 I have a doubt about how indexed properties works in Alfresco 4.1.6 with SOLR.I use something like this for my queries<IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />earchParameters sp = new SearchParameters();sp.addStore(StoreRef.STORE_REF_WORKSPACE_SPACESSTORE);sp.setLanguage(SearchService.LANGUAGE_FTS_ALFRESCO);sp.setQuery(query);ResultSet r Mon, 06 Jul 2015 14:01:09 GMT https://connect.hyland.com/t5/alfresco-archive/use-of-indexes-in-a-query-with-solr/m-p/289531#M242661 spilby 2015-07-06T14:01:09Z Re: Use of indexes in a query (with SOLR) https://connect.hyland.com/t5/alfresco-archive/use-of-indexes-in-a-query-with-solr/m-p/289532#M242662 <HTML><HEAD></HEAD><BODY><SPAN>SOLR4 is very good at indexing properties.&nbsp; Don't worry about it.&nbsp;&nbsp; And don't think of them as oracle indexes.</SPAN></BODY></HTML> Mon, 06 Jul 2015 15:40:30 GMT https://connect.hyland.com/t5/alfresco-archive/use-of-indexes-in-a-query-with-solr/m-p/289532#M242662 mrogers 2015-07-06T15:40:30Z Re: Use of indexes in a query (with SOLR) https://connect.hyland.com/t5/alfresco-archive/use-of-indexes-in-a-query-with-solr/m-p/289533#M242663 <HTML><HEAD></HEAD><BODY><SPAN>Ok, but… I imagine is not the same declare a lot of index on the model, or a few. Maybe exceed number of indexs affect negatively the performance. </SPAN><BR /><BR /><SPAN>What's your recommendation? Index all the properties that I use on the search queries, and make queries with ANDs and multiple indexes? Or only works with few indexes and use one by query? </SPAN><BR /><BR /></BODY></HTML> Tue, 07 Jul 2015 07:11:05 GMT https://connect.hyland.com/t5/alfresco-archive/use-of-indexes-in-a-query-with-solr/m-p/289533#M242663 spilby 2015-07-07T07:11:05Z Re: Use of indexes in a query (with SOLR) https://connect.hyland.com/t5/alfresco-archive/use-of-indexes-in-a-query-with-solr/m-p/289534#M242664 <HTML><HEAD></HEAD><BODY><SPAN>Let SOLR do the work.&nbsp; Its very good!&nbsp;&nbsp; Probably much better than trying to code it yourself.</SPAN></BODY></HTML> Tue, 07 Jul 2015 10:39:30 GMT https://connect.hyland.com/t5/alfresco-archive/use-of-indexes-in-a-query-with-solr/m-p/289534#M242664 mrogers 2015-07-07T10:39:30Z