Re: [2] Reindex only records that changed

2007-03-06 Thread Debra

I would like to avoid such  a field in case  tables are updated  in programs
not under my control + any program that updates these tables has to add
logic for updating this field.


Sergey Polzunov-2 wrote:
 
 additional field in your DB as flag? 1 - dirty, 0 - clean.
 
 Debra wrote:
 Hi all,

 This is not a direct solr issue but I need it for indexing.

 Is there a way to check if a database record changed since the last index
 (with out using a specail flag field that has to be set any-where the
 record
 is updated). I would like to re-index only records that changed.

 TIA
 Debra
   
 
 
 

-- 
View this message in context: 
http://www.nabble.com/Reindex-only-records-that-changed-tf3358652.html#a9343307
Sent from the Solr - User mailing list archive at Nabble.com.



Re: [2] Reindex only records that changed

2007-03-06 Thread Ryan McKinley

MySQL has a TIMESTAMP field that can autoupdate everytime something
changes... i've never used it, but that may be a place to look.

alternativly you could add a TRIGGER to automatticaly dump stuff to a
bucket when it changes and clear the bucket when you index


On 3/6/07, Debra [EMAIL PROTECTED] wrote:


I would like to avoid such  a field in case  tables are updated  in programs
not under my control + any program that updates these tables has to add
logic for updating this field.


Sergey Polzunov-2 wrote:

 additional field in your DB as flag? 1 - dirty, 0 - clean.

 Debra wrote:
 Hi all,

 This is not a direct solr issue but I need it for indexing.

 Is there a way to check if a database record changed since the last index
 (with out using a specail flag field that has to be set any-where the
 record
 is updated). I would like to re-index only records that changed.

 TIA
 Debra





--
View this message in context: 
http://www.nabble.com/Reindex-only-records-that-changed-tf3358652.html#a9343307
Sent from the Solr - User mailing list archive at Nabble.com.