Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Lucene: Java-User

Lucene vs SQL.

 

 

Lucene java-user RSS feed   Index | Next | Previous | View Threaded


hank777 at gmail

Jul 26, 2012, 10:15 AM

Post #1 of 5 (385 views)
Permalink
Lucene vs SQL.

If I want to set up a database that is totally flat with no joins, is there any reason not to use lucene. The reasons I would be curious about are things like insert performance and whether there are any queries that either don't work in lucene or perform better in MySQL/postgres.

---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe [at] lucene
For additional commands, e-mail: java-user-help [at] lucene


findbestopensource at gmail

Jul 26, 2012, 11:16 PM

Post #2 of 5 (375 views)
Permalink
Re: Lucene vs SQL. [In reply to]

Check out these articles on this topic. Hope it helps.
http://www.findbestopensource.com/article-detail/lucene-solr-as-nosql-db
http://www.lucidimagination.com/blog/2010/04/30/nosql-lucene-and-solr/

In nutshell, It is good to use Lucene as NoSQL but better have your data
stored in some persistent store like file system or a database.

Regards
Aditya
www.findbestopensource.com


On Thu, Jul 26, 2012 at 10:45 PM, Hank Williams <hank777 [at] gmail> wrote:

> If I want to set up a database that is totally flat with no joins, is
> there any reason not to use lucene. The reasons I would be curious about
> are things like insert performance and whether there are any queries that
> either don't work in lucene or perform better in MySQL/postgres.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe [at] lucene
> For additional commands, e-mail: java-user-help [at] lucene
>
>


felipe.carvalho at gmail

Jul 27, 2012, 9:25 AM

Post #3 of 5 (375 views)
Permalink
Re: Lucene vs SQL. [In reply to]

Please forgive my lack of knowledge on this theme, but why cannot Lucene /
Solr cannot be used as primary database / data store?

On Fri, Jul 27, 2012 at 3:16 AM, Aditya <findbestopensource [at] gmail>wrote:

> Check out these articles on this topic. Hope it helps.
> http://www.findbestopensource.com/article-detail/lucene-solr-as-nosql-db
> http://www.lucidimagination.com/blog/2010/04/30/nosql-lucene-and-solr/
>
> In nutshell, It is good to use Lucene as NoSQL but better have your data
> stored in some persistent store like file system or a database.
>
> Regards
> Aditya
> www.findbestopensource.com
>
>
> On Thu, Jul 26, 2012 at 10:45 PM, Hank Williams <hank777 [at] gmail> wrote:
>
> > If I want to set up a database that is totally flat with no joins, is
> > there any reason not to use lucene. The reasons I would be curious about
> > are things like insert performance and whether there are any queries that
> > either don't work in lucene or perform better in MySQL/postgres.
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: java-user-unsubscribe [at] lucene
> > For additional commands, e-mail: java-user-help [at] lucene
> >
> >
>


dotsid at gmail

Jul 27, 2012, 3:41 PM

Post #4 of 5 (375 views)
Permalink
Re: Lucene vs SQL. [In reply to]

The main idea behind Lucene is search the data. In most fast and scalable way possible. For achieving this goal Lucene give up on original data availability and consistency. So you should be ready to discard your index and rebuild it from scratch. To do this, you need to have your original data. The most frequent reason for reindex is changing Analyzer algorithms, I guess.

On Jul 28, 2012, at 3:25 AM, Felipe Carvalho <felipe.carvalho [at] gmail> wrote:

> Please forgive my lack of knowledge on this theme, but why cannot Lucene /
> Solr cannot be used as primary database / data store?
>
> On Fri, Jul 27, 2012 at 3:16 AM, Aditya <findbestopensource [at] gmail>wrote:
>
>> Check out these articles on this topic. Hope it helps.
>> http://www.findbestopensource.com/article-detail/lucene-solr-as-nosql-db
>> http://www.lucidimagination.com/blog/2010/04/30/nosql-lucene-and-solr/
>>
>> In nutshell, It is good to use Lucene as NoSQL but better have your data
>> stored in some persistent store like file system or a database.
>>
>> Regards
>> Aditya
>> www.findbestopensource.com
>>
>>
>> On Thu, Jul 26, 2012 at 10:45 PM, Hank Williams <hank777 [at] gmail> wrote:
>>
>>> If I want to set up a database that is totally flat with no joins, is
>>> there any reason not to use lucene. The reasons I would be curious about
>>> are things like insert performance and whether there are any queries that
>>> either don't work in lucene or perform better in MySQL/postgres.
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: java-user-unsubscribe [at] lucene
>>> For additional commands, e-mail: java-user-help [at] lucene
>>>
>>>
>>

---
Denis Bazhenov <dotsid [at] gmail>






---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe [at] lucene
For additional commands, e-mail: java-user-help [at] lucene


injecteer at yahoo

Aug 1, 2012, 4:13 AM

Post #5 of 5 (349 views)
Permalink
Re: Lucene vs SQL. [In reply to]

If you tokenize AND store fields in your document, you can always pull them
and re-invert using another analyzer, so you don't need to store the
"original data" somewhere else.

The point is rather the performance. I started a discussion on that topic
http://lucene.472066.n3.nabble.com/Performance-of-storing-data-in-Lucene-vs-other-No-SQL-Databases-tt3984704.html
here



--
View this message in context: http://lucene.472066.n3.nabble.com/Lucene-vs-SQL-tp3997494p3998573.html
Sent from the Lucene - Java Users mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe [at] lucene
For additional commands, e-mail: java-user-help [at] lucene

Lucene java-user RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.