Solr is not a database and it does not handle SQL queries. --wunder On Jul 2, 2013, at 9:09 AM, fabio1605 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. -- Walter Underwood wun...@wunderwood.org
