Re: Data in the Index [was: JdbcDirectory]

2007-09-04 Thread Chris Lu
I store Lucene index outside database, and run indexing periodically to get the latest updates, not depending on ORM APIs. In general, search data can be slower to update unless some realtime requirements. Storing data in index saves trips to databases. This usually is a huge difference on renderi

Re: Data in the Index [was: JdbcDirectory]

2007-09-04 Thread Patrick Turcotte
Hi, At first, we thought we would use a "dual" approach, an Lucene index and a RDBMS for storage. While prototyping, for simplicity sake, we used the Lucene index as storage, thinking we could easily replace it later. So far, speed is satisfying enough that we are going to keep data there util re