Re: Solr performance using fq with multiple values

2020-04-18 Thread Shawn Heisey
On 4/18/2020 12:20 PM, Odysci wrote: We don't used this field for general queries (q:*), only for fq and faceting. Do you think making it indexed="true" would make a difference in fq performance? fq means "filter query". It's still a query. So yes, the field should be indexed. The query

Re: Solr performance using fq with multiple values

2020-04-18 Thread Odysci
We don't used this field for general queries (q:*), only for fq and faceting. Do you think making it indexed="true" would make a difference in fq performance? Thanks Reinaldo On Sat, Apr 18, 2020 at 3:06 PM Sylvain James wrote: > Hi Reinaldo, > > Involved fields should be indexed for better

Re: Solr performance using fq with multiple values

2020-04-18 Thread Sylvain James
Hi Reinaldo, Involved fields should be indexed for better performance ? Sylvain Le sam. 18 avr. 2020 à 18:46, Odysci a écrit : > Hi, > > We are seeing significant performance degradation on single queries that > use fq with multiple values as in: > > fq=field1_name:(V1 V2 V3 ...) > > If we

Solr performance using fq with multiple values

2020-04-18 Thread Odysci
Hi, We are seeing significant performance degradation on single queries that use fq with multiple values as in: fq=field1_name:(V1 V2 V3 ...) If we use only one value in the fq (say only V1) we get Qtime = T ms As we increase the number of values, say to 5 values, Qtime more than triples, even

Re: Index using CSV file

2020-04-18 Thread Jörn Franke
Please also do not forget that you should create a schema in the Solr collection so that the data is correctly indexed so that you get fast and correct query result. I usually recommend to read one of the many Solr books out there to get started. This will save you a lot of time. > Am

Re: Index using CSV file

2020-04-18 Thread Jörn Franke
This you don’t do via the Solr UI. You have many choices amongst others 1) write a client yourself that parses the csv and post it to the standard Update handler https://lucene.apache.org/solr/guide/8_4/uploading-data-with-index-handlers.html 2) use the Solr post tool

Index using CSV file

2020-04-18 Thread Shravan Kumar Bolla
Hi, I'm trying to import data from CSV file from Solr UI and I am completely new to Solr. Please provide the necessary configurations to achieve this.

Re: Indexing data from multiple data sources

2020-04-18 Thread RaviKiran Moola
Hi, Greetings of the day!!! Unfortunately we have enclosed our database source details in the Solr community post while sending our queries to solr support as mentioned in the below mail. We find that it has been posted with this link

Indexing data from multiple data sources(CSV, RDBMS)

2020-04-18 Thread Shravan Kumar Bolla
Hi, I am working on indexing data from multiple data sources using a single collection. I specified data sources information in the data-config file and also updated managed schema.xml by adding the fields from all the data sources by specifying the common unique key across all the sources.