I want to implement Lucene for full text search. I have a table with 6 million records in an sql database. Each minute around thousand new rows will be added from the application.
Index creation in Lucene takes a lot of time. Each time I delete or create a new index from the database because the user needs to see the updated records on search.
How can I have fast enough search capability?
1) I need updated and history values on search 2) The maximum delay should be 2 seconds