[teiid-issues] [JBoss JIRA] (TEIID-5234) Improve Oracle metadata import

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5234?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13523954#comment-13523954 ] 

Steven Hawkins commented on TEIID-5234:
---------------------------------------

>From a cursory search I didn't see that this was something that could be set except via the connection or system property (-Doracle.jdbc.useFetchSizeWithLongColumn=true), so we'll just document this for now.

> Improve Oracle metadata import
> ------------------------------
>
>                 Key: TEIID-5234
>                 URL: https://issues.jboss.org/browse/TEIID-5234
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: JDBC Connector
>            Reporter: Ramesh Reddy
>            Assignee: Steven Hawkins
>
> It has been verified that if import uses the following URL property
> {code}
> useFetchSizeWithLongColumn=true 
> {code}
> it significantly improves the metadata load process, especially when there are a large number of tables in a schema. See doc [1]
> Teiid should either somehow enforce or document this.
> [1] https://docs.oracle.com/cd/E11882_01/appdev.112/e13995/oracle/jdbc/OracleDriver.html



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)