SOLR 6.6 with MS-SQL.

[Fiz Ahmed]

Hi SOLR Experts,

             We are using Apache Solr 6.6 stand-alone currently in a number
of locations.Most indexes are holding 250,000 to 400,000 documents.Our data
comes from MS-SQL.We’re using a front-end JavaScript solution to
communicate with Solr to perform queries.


   - Solr Performance


   - We have machine that are running on limited resources. Our Indexes
      (more-so Deltas) are seemingly causing system slowdowns.


   - Can we improve how our Deltas function?
         - Frequency of Deltas: How frequent should they be ideally.


   - Garbage Collection tuning:


   - How can we tune our JVM garbage collection to improve overall
         performance?


   - Java Heap Memory Settings:


   - How can we tune this to ensure the best memory usage.



Thanks & Regards
Fiz  N Coleman
AML Team.