Uploaded image for project: 'Solr'
  1. Solr
  2. SOLR-1262

DIH needs support for callable statements

    Details

    • Type: Improvement
    • Status: Reopened
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 1.3
    • Fix Version/s: None
    • Labels:
      None
    • Environment:

      linux
      mysql

      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.

        Attachments

          Activity

            People

            • Assignee:
              noble.paul Noble Paul
              Reporter:
              abdollar Abdul Chaudhry
            • Votes:
              7 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated: