Re: auto trigger the delta import to update index in solr if any update in sql database

hi thanks but I think this one is for ms sql not for mysql regards Rohan On Wed, Feb 6, 2013 at 11:53 AM, jp wrote: > The following link provides on using external activator for tracking DB > changes > http://ajitananthram.wordpress.com/2012/05/26/auditing-external-activator/ > > --JP > >

Re: auto trigger the delta import to update index in solr if any update in sql database

The following link provides on using external activator for tracking DB changes http://ajitananthram.wordpress.com/2012/05/26/auditing-external-activator/ --JP -- View this message in context: http://lucene.472066.n3.nabble.com/auto-trigger-the-delta-import-to-update-index-in-solr-if-any-updat

Re: auto trigger the delta import to update index in solr if any update in sql database

hi jp thanks can you provide me any good link for thisthanks regards Rohan On Tue, Feb 5, 2013 at 6:52 PM, jp wrote: > You could use SQL service Broker External Activation service to monitor the > changes and post the changes into the Solr Index using update request > handler in soft commi

Re: auto trigger the delta import to update index in solr if any update in sql database

You could use SQL service Broker External Activation service to monitor the changes and post the changes into the Solr Index using update request handler in soft commit mode --JP -- View this message in context: http://lucene.472066.n3.nabble.com/auto-trigger-the-delta-import-to-update-index-

Re: auto trigger the delta import to update index in solr if any update in sql database

If your field changes that often, you probably do not want to reindex Solr to match. You will loose all caches on every commit. Maybe you are looking at something like ExternalFileField but backed by a database? http://sujitpal.blogspot.ca/2011/05/custom-sorting-in-solr-using-external.html Regard

Re: auto trigger the delta import to update index in solr if any update in sql database

that is gud but it will not take care of the field that is dynamical changing like and want to do realtime update for that fieldits not possible to set cron to cal DIH every second... On Tue, Feb 5, 2013 at 5:19 PM, Alexandre Rafalovitch wrote: > If you have your deltaQuery setup in DIH, that

Re: auto trigger the delta import to update index in solr if any update in sql database

If you have your deltaQuery setup in DIH, that should check for updates. Then you just ping DIH Url periodically to get it to check. Regards, Alex. Personal blog: http://blog.outerthoughts.com/ LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch - Time is the quality of nature that keeps