Re: Maintaining index for "flattened" database tables

2011-01-13 Thread sol myr
Sounds good, thanks :) --- On Thu, 1/13/11, mark harwood wrote: From: mark harwood Subject: Re: Maintaining index for "flattened" database tables To: java-user@lucene.apache.org Date: Thursday, January 13, 2011, 6:20 AM Probably off-topic for a Lucene list but the typical database o

Re: Maintaining index for "flattened" database tables

2011-01-13 Thread mark harwood
Probably off-topic for a Lucene list but the typical database options are: 1) an auto-updated "last changed" timestamp column on related tables that can be queried 2) a database trigger automatically feeding a "to-be-indexed" table Option 1 would also need a "marked as deleted" column adding to