lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sundar shankar <>
Subject RE: Deletion of indexes.
Date Mon, 12 Jan 2009 18:19:01 GMT

When I asked the user group sometime back about the same problem, One other solution I got
was to have a soft delete column. (A column where u maintain a delete flag) . 

> Date: Mon, 12 Jan 2009 11:03:52 -0700
> From:
> To:
> Subject: Re: Deletion of indexes.
> I got around this problem by using a trigger on the table I index that 
> records the values of deleted items in a queue table so when my next 
> Solr update rolls around it sends a remove request for that record's 
> ID.  Once the Solr deletion is done, I remove that ID from the queue 
> table.  Of course, you have to be on MySQL 5.0 or above to have that 
> available to you.  Otherwise, you'll have to manually add something to 
> your deletion queries to record all the IDs you're about to delete to a 
> queue table.
> Ryan T. Grange, IT Manager
> DollarDays International, Inc.
> Tushar_Gandhi wrote:
> > Hi,
> >    I am using solr 1.3. I am facing a problem to delete the index.
> > I have mysql database. Some of the data from database is deleted, but the
> > indexing for those records is still present. Due to that I am getting those
> > records in search result. I don't want this type of behavior. I want to
> > delete those indexes which are not present in database. Also, I don't know
> > which records are deleted from database and present in index. Is there any
> > way to solve this problem? Also I think that re indexing will not solve my
> > problem, because it will re index only the records which are present in
> > database and don't bother about the indexes which don't have reference in
> > database.
> >
> > Can anyone have solution for this?
> >
> > Thanks,
> > Tushar
> >   

Much more than email – don't miss out on the rest of the Windows Live™.
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message