[SOLR-1262] DIH needs support for callable statements

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 1.3
• Component/s: contrib - DataImportHandler

Environment

linux
mysql

• Assignee: Noble Paul
• Reporter: Abdul Chaudhry
• Created: 06/Jul/09 22:38
• Updated: 29/Aug/20 18:26
• Resolved: 29/Aug/20 18:26

Description

During an indexing run we noticed that we were spending a lot of time creating and tearing down queries in mysql

The queries we are using are complex and involve joins spanning across multiple tables.

We should support prepared statements in the data import handler via the data-config.xml file - for those databases that support prepared statements.

We could add a new attribute to the entity entity in dataConfig - say - pquery or preparedQuery and then pass the prepared statement and have values filled in by the actual queries for each row using a placeholder - like a ? or something else.

I would probably start by hacking class JdbcDataSource to try a test but was wondering if anyone had experienced this or had any suggestions or if there is something in the works that I missed - I couldn't find any other bugs mentioning using prepared statements for performance.

Issue Links

• is superceded by: SOLR-14783 Remove DIH from 9.0