You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Debra <de...@netvision.net.il> on 2007/03/06 23:06:10 UTC
Reindex only records that changed
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#a9342185
Sent from the Solr - User mailing list archive at Nabble.com.
Re: [2] Reindex only records that changed
Posted by Debra <de...@netvision.net.il>.
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 <de...@netvision.net.il> 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.
Re: [2] Reindex only records that changed
Posted by Ryan McKinley <ry...@gmail.com>.
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 <de...@netvision.net.il> 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
Posted by Debra <de...@netvision.net.il>.
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: Reindex only records that changed
Posted by Traut <tr...@gmail.com>.
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
>