Re: [2] Reindex only records that changed
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
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.
Re: [2] Reindex only records that changed
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 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. >> >> > > -- View this message in context: http://www.nabble.com/Reindex-only-records-that-changed-tf3358652.html#a9362463 Sent from the Solr - User mailing list archive at Nabble.com.