topic Re: 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/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 spilby 2015-07-07T07:11:05Z 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