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-03 Thread David Quarterman
In Action by Trey Grainger Tim Potter. If you need help, shout! It's a great community. Cheers, DQ -Original Message- From: fabio1605 [mailto:fabio.to...@btinternet.com] Sent: 03 July 2013 09:55 To: solr-user@lucene.apache.org Subject: Re: Newbie SolR - Need advice Hi Sandeep Thank you

Re: Newbie SolR - Need advice

2013-07-03 Thread Jack Krupansky
-Original Message- From: fabio1605 Sent: Wednesday, July 03, 2013 4:55 AM To: solr-user@lucene.apache.org Subject: Re: Newbie SolR - Need advice 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

Re: Newbie SolR - Need advice

2013-07-03 Thread Sandeep Mestry
of Solr or SQL. That's the best starting point. -- Jack Krupansky -Original Message- From: fabio1605 Sent: Wednesday, July 03, 2013 4:55 AM To: solr-user@lucene.apache.org Subject: Re: Newbie SolR - Need advice Hi Sandeep Thank you for your reply Il have a read through

Re: Newbie SolR - Need advice

2013-07-02 Thread Jack Krupansky
Start with the Solr Tutorial. http://lucene.apache.org/solr/tutorial.html -- Jack Krupansky -Original Message- From: fabio1605 Sent: Tuesday, July 02, 2013 11:16 AM To: solr-user@lucene.apache.org Subject: Newbie SolR - Need advice Hi we have a MSSQL Server which is just getting

RE: Newbie SolR - Need advice

2013-07-02 Thread David Quarterman
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

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 Sandeep Mestry
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

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 Jack Krupansky
.nabble.com Date: 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 Shawn Heisey
On 7/2/2013 10: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

Re: Newbie SolR - Need advice

2013-07-02 Thread Walter Underwood
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

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 David Quarterman
] Sent: 02 July 2013 17:10 To: solr-user@lucene.apache.org Subject: RE: Newbie SolR - Need advice 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

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,

Re: Newbie SolR - Need advice

2013-07-02 Thread Sandeep Mestry
Hi Fabio, Yes, you're on right track. I'd like to now direct you to first reply from Jack to go through solr tutorial. Even with Solr,, it will take some time to learn various bits and pieces about designing fields, their field types, server configuration, etc. and then tune the results to match