Re: [2] Reindex only records that changed

2007-03-07 Thread Debra
Thanks for the good advice. ryan mckinley wrote: > > 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 c

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

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