Hi all,
I have a design decission to make. I am using Lucene (Java Search
API) and I need to update lucenes index from time to time.
Is there a way one can keep track of all the inserts coming
into a table (holding onto their Primary key's are sufficient) and
then reseting that after a certain time period?
I have an idea(see below), but your suggestions would be appreicated.
1) Create a view from the table (empty). Have a trigger that inserts
into the view everytime that table gets updated. Then when that view
gets read by the necessary piece of code, the view gets emptied
(deleted and a new view is created). Not sure if this will work.
Any help is much appreciated.
-assad