I was thinking that perhaps I can pre-stem words before sticking them in a search field in the database perhaps using Lucene stemming code, then try to use the Natural Language Search found in MySql 4.1.1. I am confident the MySql product can't keep up with Lucene yet, but at least they hvae improved it some. Not even sure if my hosting company will upgrade to 4.1.1 though. Still looking for a lot of solutions to make Lucene sit in synch more nicely with MySql as the main database...aka an easy to use way of handling
----- Original Message ----- From: Chris Lamprecht <[EMAIL PROTECTED]> Date: Wednesday, November 17, 2004 1:38 am Subject: Re: Index Locking Issues Resolved...I hope > MySQL does offer a basic fulltext search (with MyISAM tables), but it > doesn't really approach the functionality of Lucene, such as pluggable > tokenizers, stemming, etc. I think MS SQL server has fulltext search > as well, but I have no idea if it's any good. > > See > http://www.google.com/search?hl=en&lr=&safe=off&c2coff=1&q=mysql+fulltext > > I have not seen clear yet because it is all new. I wish a > database Text field could have this sort of mechanism built into > it. MySql does not do this (what I am using), but I am going to > check into other databases now. OJB will work with most all of > them so that would help if there is a database type of solution > that will allow that sleep at night thing to happen!!! > > > > ------------------------------------------------------------------- > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
