Newbie SolR - Need advice

2013-07-02 Thread fabio1605
Hi we have a MSSQL Server which is just getting far to large now and performance is dying! the majority of our webservers mainly are doing search function so i thought it may be best to move to SolR But i know very little about it! My questions are! Does SolR Run as a bolt on to MSSQL - as in th

RE: Newbie SolR - Need advice

2013-07-02 Thread fabio1605
is mongo and how does it compare I just don't understand how in 10years of Web development I have never heard of SolR till last week Sent from Samsung Mobile Original message From: "David Quarterman [via Lucene]" Date: 02/07/2013 16:57 (GMT+00:00)

Re: Newbie SolR - Need advice

2013-07-02 Thread fabio1605
3 17:29 (GMT+00:00) To: fabio1605 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 is not a replacement for any database as it does

Re: Newbie SolR - Need advice

2013-07-02 Thread fabio1605
Arrfh I see...  So SolR is the search engine for a datastore  Is that what mongo is.. A datastore bit.  Sent from Samsung Mobile Original message From: "Jack Krupansky-2 [via Lucene]" Date: 02/07/2013 17:51 (GMT+00:00) To: fabio1605 Subject: Re: Newbie S

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, i

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: http://luc