Re: Newbie SolR - Need advice

2013-07-03 Thread fabio1605
Hi Sandeep Thank you for your reply Il have a read through the tutorials now that i understand the principle of all this, i would ideally like to keep mssql and bolt solr on top of this so that we can keep mssql as we have a 200GB database Cheers -- View this message in context:

RE: Newbie SolR - Need advice

2013-07-02 Thread fabio1605
:57 (GMT+00:00) To: fabio1605 fabio.to...@btinternet.com Subject: RE: Newbie SolR - Need advice Hi Fabio, Like Jack says, try the tutorial. But to answer your question, SOLR isn't a bolt on to SQLServer or any other DB. It's a fantastically fast indexing/searching tool. You'll need to use

Re: Newbie SolR - Need advice

2013-07-02 Thread fabio1605
: 02/07/2013 17:29 (GMT+00:00) To: fabio1605 fabio.to...@btinternet.com Subject: Re: Newbie SolR - Need advice Hi Fabio, No, Solr isn't the database replacement for MS SQL. Solr is built on top of Lucene which is a search engine library for text searches. Solr in itself

Re: Newbie SolR - Need advice

2013-07-02 Thread fabio1605
) To: fabio1605 fabio.to...@btinternet.com Subject: Re: Newbie SolR - Need advice Consider DataStax Enterprise - it combines Cassandra for NoSql data storage with Solr for indexing - fully integrated. http://www.datastax.com/ -- Jack Krupansky -Original Message- From: fabio1605 Sent

RE: Newbie SolR - Need advice

2013-07-02 Thread fabio1605
So, you keep your mssql database, you just don't use it for searches - that'll relieve some of the load. Searches then all go through SOLR its Lucene indexes. If your various tables need SQL joins, you specify those in the DataImportHandler (DIH) config. That way, when SOLR indexes everything,