spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Wu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SPARK-7746) SetFetchSize for JDBCRDD's prepareStatement
Date Tue, 19 May 2015 23:48:00 GMT
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


Mime
View raw message