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 not support any relational db features, however as Jack and David mentioned its fully optimised search engine platform that can provide all search related features like faceting, highlighting etc. Solr does not have a *database*. It stores the data in binary files called indexes <http://lucene.apache.org/core/3_0_3/fileformats.html>. These indexes are populated with the data from the database. Solr provides an inbuilt functionality through DataImportHandler component to get the data and generate indexes. When you say, your web servers are mainly doing search function, do you mean it is a text search and you use queries with clauses as 'like', 'in' etc. (in addition to multiple joints) to get the results? Does the web application need faceting? If yes, then solr can be your friend to get it through. Do remember that it always takes some time to get the new concepts from understanding through to implementation. As David mentioned already, it *is* going to be a bumpy ride at the start but *definitely* a sensational one. Good Luck, Sandeep On 2 July 2013 17:09, fabio1605 <fabio.to...@btinternet.com> wrote: > Thanks guys > > So SolR is actually a database replacement for mssql... Am I right.... > > > We have a lot of perl scripts that contains lots of sql insert > queries..... Etc > > > How do we query the SolR database from scripts.... I know I have a lot to > learn still so excuse my ignorance. > > Also... What 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]" < > ml-node+s472066n4074772...@n3.nabble.com> > Date: 02/07/2013 16: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 the DataImportHandler (see the > tutorial) to import your data from the DB into the indices that SOLR uses. > Once in there, you'll have more power & flexibility than SQLServer would > ever give you! > > Haven't tried SOLR on Windows (I guess your environment) but I'm sure > it'll work using Jetty or Tomcat as web container. > > Stick with it. The ride can be bumpy but the experience is sensational! > > DQ > > -----Original Message----- > From: fabio1605 [mailto:[hidden email]] > Sent: 02 July 2013 16:16 > To: [hidden email] > Subject: Newbie SolR - Need advice > > 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 the data is still in MSSQL and > SolR is just the search bit between? > > Im really struggling to understand the point of SOLR etc so if someone > could point me to a Dummies website id apprecaite it! google is throwing to > much confusion at me! > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Newbie-SolR-Need-advice-tp4074746.html > Sent from the Solr - User mailing list archive at Nabble.com. > > > If you reply to this email, your message will be added to the discussion > below: > > http://lucene.472066.n3.nabble.com/Newbie-SolR-Need-advice-tp4074746p4074772.html > To unsubscribe from Newbie SolR - Need advice, click here. > NAML > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Newbie-SolR-Need-advice-tp4074746p4074782.html > Sent from the Solr - User mailing list archive at Nabble.com. >
