Return-Path: Delivered-To: apmail-lucene-java-user-archive@www.apache.org Received: (qmail 47292 invoked from network); 14 Apr 2006 03:05:58 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 14 Apr 2006 03:05:58 -0000 Received: (qmail 60083 invoked by uid 500); 14 Apr 2006 03:05:51 -0000 Delivered-To: apmail-lucene-java-user-archive@lucene.apache.org Received: (qmail 60055 invoked by uid 500); 14 Apr 2006 03:05:50 -0000 Mailing-List: contact java-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: java-user@lucene.apache.org Delivered-To: mailing list java-user@lucene.apache.org Received: (qmail 60043 invoked by uid 99); 14 Apr 2006 03:05:50 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Apr 2006 20:05:50 -0700 X-ASF-Spam-Status: No, hits=1.9 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,MSGID_FROM_MTA_HEADER,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of tonyqian@hotmail.com designates 65.54.229.31 as permitted sender) Received: from [65.54.229.31] (HELO hotmail.com) (65.54.229.31) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Apr 2006 20:05:48 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 13 Apr 2006 20:05:28 -0700 Message-ID: Received: from 65.54.229.220 by by110fd.bay110.hotmail.msn.com with HTTP; Fri, 14 Apr 2006 03:05:25 GMT X-Originating-IP: [24.33.231.193] X-Originating-Email: [tonyqian@hotmail.com] X-Sender: tonyqian@hotmail.com From: "Tony Qian" To: java-user@lucene.apache.org Subject: Re: full text search using Lucene Date: Fri, 14 Apr 2006 03:05:25 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 14 Apr 2006 03:05:28.0445 (UTC) FILETIME=[488772D0:01C65F70] X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Chris, Thanks for your reply. I'm currently evaluating different products for full text search. I visited DBSight web site briefly. Basically, I have a main table which has a number of fields for Ids from look-up tables, for example category_id, brand_id, product_id etc. Main table also has a description and detail columns. After user types a number of keywords in a text box. My query needs to search category table, brand table, product table, main table etc. to see if anything matches. If matching, need to retrieve the record from main table. I didn't see this kind of example at DBsight web site. I'm just wondering if DBSight can do that. Thanks, Tony >From: "Chris Lu" >Reply-To: java-user@lucene.apache.org >To: java-user@lucene.apache.org >Subject: Re: full text search using Lucene >Date: Mon, 10 Apr 2006 22:18:44 -0700 > >Hi, Tony, > >DBSight, like SearchBlox, Nutch, Solr, is using Lcuene to search. It >just makes it super easy and flexible to create a search on any >databases. Lucene's implementation is far more superior and flexible >to MySql's full text search. > >Try it and you will know what I am talking about. Actually, I think >it'll be faster to setup DBSight, have it running, see the results, >than reading through marketing materials. :) > >Right now, no funding for us. We need to sell it at a meager price. >Otherwise, we would be very willing to donate it to open source. > >Chris Lu >----------------------------------------- >Full-Text Search on Any Databases >http://www.dbsight.net >Faster to setup than reading marketing materials. > >On 4/10/06, Tony Qian wrote: > > All, > > > > I'm working on a project which requires full text search on multiple >tables > > in MySql database. Although, MySql supports full text search, it only > > supports full text search on signle table. I'm wondering if Lucene can >help > > me to do full text search against MySql database. (I noticed that >DBSight is > > built on top of Lucene.) > > > > Any suggestion and links pointing to examples and tutorial are >appreaciated. > > > > Tony > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org > > For additional commands, e-mail: java-user-help@lucene.apache.org > > > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org >For additional commands, e-mail: java-user-help@lucene.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org For additional commands, e-mail: java-user-help@lucene.apache.org