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
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