From: "leegold" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: RE: Lucene with MYSQL Date: Thu, 29 Jul 2004 16:56:23 -0400
...snip...
>
> This combination works fine for some scenarios but it doesnt for
> others, in some cases the best choice is to use the FullText feature
> available in MySQL which employs the same Vectorial Model that
> Lucene's do. One advantage of Lucene is that is composed of layers and
> you can modify it to use different models instead of uniquely the
> Vectorial; on the other hand Lucene doesnt support concurrency which
> can be a serious problem in your application or maybe not.
Could you just briefly explain "layers" and "concurrency" maybe w/a simple real-life example so I can see the contrast between the two searchs? Thanks very much, Lee G.
Sure,
i mean layers relating about java packages, Lucene have different packages to store, index, retrieve, apply IR model, etc, so for example if you want to use a different index schema you can modify that package and improve or customize that "layer", the same applies to IR models, most models are based on frequency, collection size, etc those methods are available so you can build an entirely new algorithm (ie. Latent Semantic) with the core indexing of Lucene.
About concurrency, MySQL is a "engine" that supports thousand connections at the same time and mantains some indexes in memory (even Full Text indexes i think, someone at MySQL can confirm this ?) so every operation is very fast; Lucene is not an engine its an API, so every add/update must check if the index file is locked, wait and so on. If you need something more robust in this way MySQL is the best choice; if you are thinking in something more "static" than doesnt update frequently then Lucene can be a good one.
Lucene's faq and http://today.java.net/pub/a/today/2003/07/30/LuceneIntro.html are good references for more details.
regards
Carlos Proal
> > Hope my 5 cents works to you :) > > Carlos Proal > > > ----Original Message Follows---- From: "leegold" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] Subject: Lucene with MYSQL Date: Thu, 29 Jul > 2004 13:36:56 -0400 > > Is it possible to use the Lucene fulltext search on a MYSQL database - > say for text type fields? > > _________________________________________________________________ > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > http://join.msn.com/?page=features/virus >
--
_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
