Re: Lucene vs Database Search

2006-08-25 Thread Chris Lu
Performance wise, Lucene search is much faster for full-text search. If you only do "Employee ID" search, or exact match of Names, database's search can do a good job already. If it's regarding the index maintenance, you should have a updated_at column for each record, and select the latest recor

Lucene vs Database Search

2006-08-24 Thread kalpesh patel
Hi, I have an application. It has large number of records around (1.2 million) with a possibility of doubling every year. The average records being added per day is around 3000 distributed over the day. The inserted record has to be searchable immediately once it is entered into the databa