You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Paul Wu (JIRA)" <ji...@apache.org> on 2015/05/20 01:48:00 UTC

[jira] [Created] (SPARK-7746) SetFetchSize for JDBCRDD's prepareStatement

Paul Wu created SPARK-7746:
------------------------------

             Summary: SetFetchSize for JDBCRDD's prepareStatement
                 Key: SPARK-7746
                 URL: https://issues.apache.org/jira/browse/SPARK-7746
             Project: Spark
          Issue Type: New Feature
          Components: SQL
    Affects Versions: 1.3.1, 1.3.0
            Reporter: Paul Wu


The prepareStatement created internal to compute() method in JDBCRDD should have some options that the setFetchSize() can be set.  We found that the parameter can affect Oracle DB tremendously. With current implementation, we have no way to set the size.  

One of my team did his implementation, and we found 10X improvement by setting the size to a proper number. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org