The general solution is to add a "deleted" column to your database, or even a "deleted date" column.
When you update Solr from the DB, issue a delete for each item deleted since the last successful update. You can delete those rows after the Solr update or to be extra safe, delete them a few days later. For this to work, you must not re-use IDs. wunder On Jan 24, 2013, at 10:05 AM, hassancrowdc wrote: > Hi, > I am trying to figure out a way so that if i delete anything from my > database how will that item be deleted from my indexed data? > is there anyway i can make new core with same config as the existing core, > do full index, swap the data with the existing core and delete the new core. > So every time i delete anything from database, it creates a new core, index > data, swap it and then delete the new core(that was made)? > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Deletion-from-database-tp4036018.html > Sent from the Solr - User mailing list archive at Nabble.com.
