Re: Solr 6.6.0 - DIH - Multiple entities - Multiple DBs

2019-07-11 Thread Joseph_Tucker
Thanks For the help. Looks like I've managed to get some semblance of this working. The indexes are much faster, but the RAM usage by SolrJ is quite high. Is it normal to see around 6GB of RAM usage? (My test is indexing 250,000 records with the 50 child entities) In short, I'm running through a

Re: Solr 6.6.0 - DIH - Multiple entities - Multiple DBs

2019-07-08 Thread Joseph_Tucker
Thanks again. I guess I'll have to start researching how to create such custom indexing scripts and determine which language would be best based on the environment I'm using (Azure in this case). Appreciate the help greatly Charlie Hull-3 wrote > On 05/07/2019 14:33, Joseph

Re: Solr 6.6.0 - DIH - Multiple entities - Multiple DBs

2019-07-05 Thread Joseph_Tucker
Thanks for your help / suggestion. I'm not sure I completely follow in this case. SolrJ looks like a method to allow Java applications to talk to Solr, or any other third party application would simply be a communication method between Solr and the language of your choosing. I guess what I'm aft

Solr 6.6.0 - DIH - Multiple entities - Multiple DBs

2019-07-05 Thread Joseph_Tucker
What is the best way - performance wise - to index data from multiple databases? I'm potentially going to have around 50 different data sources grabbing unique data Here's what I've roughly designed: ... I've excluded fields but each entity

Solr 6.6.0 - Multiple DataSources - Performance / Delta Issues - MSSQL(Azure)

2019-06-26 Thread Joseph_Tucker
I've currently got a data configuration that uses multiple dataSources. I have a main dataSource that contains shared inventory data, and individual dataSources that contain price data that differs from database to database. (I have little to no say in how the Databases can be structured) The scen

Solr 6.6.0 - Indexing Multiple DataSources multiple child entities

2019-06-26 Thread Joseph_Tucker
[Using Solr 6.6.0] I've currently got a few databases that I'm indexing. To give the scenario: I have 10 different shops Each shop will have the same inventory, but different price tags on each item. (i.e. Shop 1 sells Chocolate for $1, and Shop 2 sells Chocolate for $0.95... etc) I'm connecting t