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 "mss.mss" <ms...@gmail.com> on 2011/08/27 15:14:44 UTC

getting old records in database

hi

   we developed a solr and connected to database and getting the
records from database. now we  deleted the records in table but iam getting
the old
records  in solr... to solve this what we have to do.

how to solve this problem

thanks in advance 

--
View this message in context: http://lucene.472066.n3.nabble.com/getting-old-records-in-database-tp3288991p3288991.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: getting old records in database

Posted by Alexei Martchenko <al...@superdownloads.com.br>.
depends on the case.

we have a database here that updates very frequently, so we just added a
field named syncid and set it to the index day. everytime the database
updates it updates the syncid to the current day. after we perform a full
database update, we tell solr to delete all records different to the current
syncid, or the current day.

its a xml with a delete query -syncid:27 will delete all records not updated
in day 27 update.

with databases that update constantly, it works.

if anyone else knows another solution, please share.

2011/8/27 mss.mss <ms...@gmail.com>

>
> hi
>
>   we developed a solr and connected to database and getting the
> records from database. now we  deleted the records in table but iam getting
> the old
> records  in solr... to solve this what we have to do.
>
> how to solve this problem
>
> thanks in advance
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/getting-old-records-in-database-tp3288991p3288991.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>



-- 

*Alexei Martchenko* | *CEO* | Superdownloads
alexei@superdownloads.com.br | alexei@martchenko.com.br | (11)
5083.1018/5080.3535/5080.3533