lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mikhail Khludnev <m...@apache.org>
Subject Re: Way for DataImportHandler to use bind variables
Date Thu, 03 May 2018 07:36:51 GMT
DIH does string replacement

https://github.com/apache/lucene-solr/blob/8b9c2a3185d824a9aaae5c993b872205358729dd/solr/contrib/dataimporthandler/src/java/org/apache/solr/handler/dataimport/SqlEntityProcessor.java#L73


Hard refactoring is required to make it use preparedStatement.
However there should be just a few jdbc calls that means it shouldn't be a
problem.
There a few DIH facilities to avoid like N+1 pitfalls.


On Wed, May 2, 2018 at 10:03 PM, Mike Konikoff <mikekonikoff@gmail.com>
wrote:

> Is there a way to configure the DataImportHandler to use bind variables for
> the entity queries? To improve database performance.
>
> Thanks,
>
> Mike
>



-- 
Sincerely yours
Mikhail Khludnev

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message