Thanks in advance. Trevor Watson
Another question for all you folk.
The project we are working on requires near instant updates on the
Lucene index when the database we have is updated. We were working with
a product called Lucene4DB to attempt to link the MySQL tables that we
are currently using (though future development may make this database
independent (plans for DB2, SQL Server are already in progress)).
After many attempts and failures in that department (basically we
couldn't even get their sample to work), we decided to instead add code
to the web service that accesses Lucene / MySQL to update Lucene each
time an entry is written to MySQL (nightmare and if it decides some day
not to write to Lucene, that'll be fun).
When we run a query on Lucene, we perform the query, retrieve the Ids
(only thing stored in the Lucene index aside from the tokenized data),
then run a query on MySQL with those IDs as the where clause.
Long story short, is there a more direct way to access MySQL data
through Lucene?
I know Sphinx search will connect directly to the database, but won't
update unless you update the entire index (which is fabulous at
2,500,000 records).
