Well, thanks a lot.
Chris Hostetter-3 wrote > The first question i have is why you are using a version of Solr that's > almost 5 years old. *Well, Solr is part of another software and integrated with this version. With next update they will also update Solr to ver. 7...* Chris Hostetter-3 wrote > The second question you should consider is what your indexing process > looks like, and whether it's multithreaded or not, and if the bottleneck > is your network/DB. *Diggin deeper into the system, shows that SQL is the bottleneck. Next to Solr around 25 applications acces the DB (110GB) and causes a load of 100% to DB memory [32GB] and disk access [SAS Raid]. The main problem is to get data out of db as fast as possible. Running into some other problems due to this circumstances. API Agent tries to deploy batch of 25 elements at once to solr but already runs into a timeout to get all the associated fields for this batch from SQL. After failing of 25 batch > 12 > 6 > 3 > 2 > 1. This ends up in at least 1 document every 7 minutes. :(* So at this time the DB admin has to do his work first. Really appreciate your thoughts on this. kindest regards Francois -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
