Re: how to update database record after indexing
Hey Erick, i written separate process as you suggested, and achieved task. Thanks a lot Vishal Parekh -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-update-database-record-after-indexing-tp2874171p3019217.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: how to update database record after indexing
I'm assuming you have some idea what *should* have been indexed in the last hour, why can't you query your Solr index with that information? You shouldn't have to examine the entire index Best Erick On Thu, May 12, 2011 at 8:20 AM, vrpar...@gmail.com vrpar...@gmail.com wrote: actually every hour some records are inserted into database, so every hour solr indexing will be called with delta import, notes: records and data are very large (in GBs) so each time to find all solr index and update database records process will be slow. is there any eventlistners or snapshooter can help me to solve this problem ? Thanks, Vishal Parekh -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-update-database-record-after-indexing-tp2874171p2931537.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: how to update database record after indexing
actually every hour some records are inserted into database, so every hour solr indexing will be called with delta import, notes: records and data are very large (in GBs) so each time to find all solr index and update database records process will be slow. is there any eventlistners or snapshooter can help me to solve this problem ? Thanks, Vishal Parekh -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-update-database-record-after-indexing-tp2874171p2931537.html Sent from the Solr - User mailing list archive at Nabble.com.
how to update database record after indexing
Hello, i am using dataimporthandler to import data from sql server database. my requirement is when solr completed indexing on particular database record i want to update that record in database or after indexing all records if i can get all ids and update all records how to achieve same ? Thanks Vishal Parekh -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-update-database-record-after-indexing-tp2874171p2874171.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: how to update database record after indexing
I don't think you can do this through DIH, you'll probably have to write a separate process that queries the Solr index and updates your table. You'll have to be a bit cautious that you coordinate the commits, that is wait for the DIH to complete and commit before running your separate db update process. Best Erick On Thu, Apr 28, 2011 at 6:59 AM, vrpar...@gmail.com vrpar...@gmail.com wrote: Hello, i am using dataimporthandler to import data from sql server database. my requirement is when solr completed indexing on particular database record i want to update that record in database or after indexing all records if i can get all ids and update all records how to achieve same ? Thanks Vishal Parekh -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-update-database-record-after-indexing-tp2874171p2874171.html Sent from the Solr - User mailing list archive at Nabble.com.