lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hoss Man (JIRA)" <>
Subject [jira] [Updated] (SOLR-1262) DIH needs support for callable statements
Date Fri, 31 Aug 2012 01:30:08 GMT


Hoss Man updated SOLR-1262:

    Fix Version/s:     (was: 4.0)

There is no indication that anyone is actively working on this issue, and it has no current
patch, so removing 4.0 from the fixVersion.

> DIH needs support for callable statements 
> ------------------------------------------
>                 Key: SOLR-1262
>                 URL:
>             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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message