You can go for solr cloud if you have billions of data and in future if you want to increase the volume. Solr is a file based database for retriving data and not for complex oprations like joining multiple tables.If your requirement is only storing and fast retrieving then solr is the best option in comparison to conventional relational db. You can configurer the no of threads from jetty server configuration .
On Sat, Sep 15, 2018 at 8:54 PM senthil <senthilkum...@sardonyx.in> wrote: > Dear Team, > > > > We are beginners to Apache Solr and its implementations. We need the > following basic clarifications regarding Apache Solr usage and implementing > with MS-SQL server database. > > > > 1. Our MS-SQL server database having the data table which contains 20 > columns with billions of data. > > > > 2. How to implement Apache Solr in the particular above table to increase > search capability? > > > > 3. Is there any way to call the data which is distributed across 2 > shards/node of Apache Solr at a time? > > > > 4. Is there any performance difference between search the data in a single > shard/node and multiple shard/node? > > > > > > > > Thanks & Regards > > > > *SENTHIL KUMAR P* > > Team Leader > > > > Office: +91-4362-243433 > > Skype: syxsenthilp > > > > *Sardonyx Technologies Pvt. Ltd.,* > > Thanjavur - 613007 > > www.sardonyx.in > > > > [image: sardonyx_logo] > > > > [image: signature-1] > > > > *From:* senthil [mailto:senthilkum...@sardonyx.in] > *Sent:* Friday, September 14, 2018 12:40 PM > *To:* 'gene...@lucene.apache.org'; 'solr-user@lucene.apache.org'; ' > d...@lucene.apache.org' > *Cc:* kulothungand; 'karthic...@sardonyx.in' > *Subject:* Need Support - Apache Solr - 20180914 > > > > Dear Team, > > > > We need the below clarifications and doubts in the “*Apache Solr*” and > please give us the solution. > > > > 1. Apache Solr is the Database or not ? > > > > 2. The limitation for Apache Solr is 2 billion records and how can > we increase it (unlimitted) ? > > > > 3. How many users can use / access Apache Solr through web > application at a time ? > > > > > > > > Thanks & Regards > > > > *SENTHIL KUMAR P* > > Team Leader > > > > Office: +91-4362-243433 > > Skype: syxsenthilp > > > > *Sardonyx Technologies Pvt. Ltd.,* > > Thanjavur - 613007 > > www.sardonyx.in > > > > [image: sardonyx_logo] > > > > [image: signature-1] > > >
