RE: Deletion from database

2013-01-24 Thread Dyer, James
apache.org/solr/DataImportHandlerFaq#fullimportdelta James Dyer E-Commerce Systems Ingram Content Group (615) 213-4311 -Original Message- From: hassancrowdc [mailto:hassancrowdc...@gmail.com] Sent: Thursday, January 24, 2013 12:19 PM To: solr-user@lucene.apache.org Subject: Re: Deletion from database

Re: Deletion from database

2013-01-24 Thread hassancrowdc
ok, how can i issue delete for each item deleted since the last successful update? Do i write something like delete query with delta import query in dataconfig? If so, what will i add in dataconfig for deletion? -- View this message in context: http://lucene.472066.n3.nabble.com/Deletion-from-

Re: Deletion from database

2013-01-24 Thread Walter Underwood
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 d