[ https://issues.apache.org/jira/browse/SOLR-1262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Erick Erickson resolved SOLR-1262. ---------------------------------- Resolution: Won't Fix 2013 Old JIRA cleanup > DIH needs support for callable statements > ------------------------------------------ > > Key: SOLR-1262 > URL: https://issues.apache.org/jira/browse/SOLR-1262 > Project: Solr > Issue Type: Improvement > Components: contrib - DataImportHandler > Affects Versions: 1.3 > Environment: linux > mysql > Reporter: Abdul Chaudhry > Assignee: Noble Paul > Priority: Minor > > 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. -- This message was sent by Atlassian JIRA (v6.1#6144) --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org