Carlos Proal wrote:
Hi, i have been using Lucene & MySQL but separately, MySQL is written in C/C++ with a JDBC driver available and Lucene is coded in Java, so (besides the mysql team opinion) you can mix searches throught both apis and referring to each other with the PrimaryKey.
Does anyone know if/how a JVM using Lucene could be used in the MySQL 5 Stored Procedure architecture (or maybe as Functions in the 4.0 architecture). If the architecture (MySQL 5) would allow for a continuous running JVM with an entry point into the Java search code then could you use Lucene code against the MySQL DB tables directly?
There are obvious places where too much data marshalling between C and Java may make the solution too slow, but I would like to investigate the possibilities.
thanks, Jon
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.
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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
