RE: Advantage of putting lucene index in RDBMS

2006-10-11 Thread sachin
: Advantage of putting lucene index in RDBMS One think, generally use RDBM for the STORED fields is good idea because every segment merging / optimize copies those data once or twice (cfs). I'm thinking about to put STORED fields in extra file and put pointers in cfs. Delete will just

Re: Advantage of putting lucene index in RDBMS

2006-10-06 Thread Karel Tejnora
One think, generally use RDBM for the STORED fields is good idea because every segment merging / optimize copies those data once or twice (cfs). I'm thinking about to put STORED fields in extra file and put pointers in cfs. Delete will just mark document as delete. And new operation omptimize_

Re: Advantage of putting lucene index in RDBMS

2006-10-05 Thread Mag Gam
I appreciate everyone's responses. I guess the main advantage of putting lucene's index into a RDBMS is for flexibility of queries. Personally, I rather use a RDBMS for results than lucene because I am more experienced with SQL queries than using Java. Does anyone have a simple example of using

Re: Advantage of putting lucene index in RDBMS

2006-10-05 Thread Aleksei Valikov
Hi. As one of the people who asked about placing indeces into RDBMS, I was primarily interested in just storing index in the RDBMS (basically, storing the structures described on this page http://lucene.apache.org/java/docs/fileformats.html in the relational DB). The main reason is NOT to be abl

Re: Advantage of putting lucene index in RDBMS

2006-10-05 Thread Aleksei Valikov
Hi. I have been reading the lists for couple of week now, and I noticed people asking about placing their indexes into a RDBMS. What is the advantage of that? So far lucene was able to solve all my problems, but I am curious how else people are using it (especially with RDBMS). Having

RE: Advantage of putting lucene index in RDBMS

2006-10-05 Thread Paul Snyder
ginal Message- From: Vladimir Olenin [mailto:[EMAIL PROTECTED] Sent: Thursday, October 05, 2006 8:41 AM To: java-user@lucene.apache.org Subject: RE: Advantage of putting lucene index in RDBMS As one of the people who asked about placing indeces into RDBMS, I was primarily interested in just st

RE: Advantage of putting lucene index in RDBMS

2006-10-05 Thread Vladimir Olenin
va calls from DB (eg, through Java Stored Procedures in case of Oracle). -Original Message- From: Paul Snyder [mailto:[EMAIL PROTECTED] Sent: Thursday, October 05, 2006 9:19 AM To: java-user@lucene.apache.org Subject: RE: Advantage of putting lucene index in RDBMS Aleksei, can you point me

RE: Advantage of putting lucene index in RDBMS

2006-10-05 Thread Paul Snyder
- From: Aleksei Valikov [mailto:[EMAIL PROTECTED] Sent: Thursday, October 05, 2006 3:39 AM To: java-user@lucene.apache.org Subject: Re: Advantage of putting lucene index in RDBMS Hi. > I have been reading the lists for couple of week now, and I noticed > people asking about placing

Re: Advantage of putting lucene index in RDBMS

2006-10-05 Thread Aleksei Valikov
Hi. I have been reading the lists for couple of week now, and I noticed people asking about placing their indexes into a RDBMS. What is the advantage of that? So far lucene was able to solve all my problems, but I am curious how else people are using it (especially with RDBMS). Having an inde

Advantage of putting lucene index in RDBMS

2006-10-04 Thread Mag Gam
I have been reading the lists for couple of week now, and I noticed people asking about placing their indexes into a RDBMS. What is the advantage of that? So far lucene was able to solve all my problems, but I am curious how else people are using it (especially with RDBMS). TIA