Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2012
    Posts
    2

    Question Unanswered: How JDBC will afffect to the source server performance?

    Our plan is using the PDI (via JDBC) for the ETL process. Our DataCenter team questioned whether the JDBC will affect to the performance of our database server (Oracle).
    In this case, it's not the the transaction performance, but for example : how the JDBC server will hold the memory source a lot or not?

    Sorry about my poor english.....

    Thanks in advance

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    There is no such thing as a "JDBC server" in Oracle.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Jul 2012
    Posts
    2
    sorry, I mean "JDBC" only .....

  4. #4
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    JDBC as the technology will not affect the performance. The queries that you send will affect the performance.

    The JDBC driver implements the native Oracle protocol to talk to the database. There is no performance difference between the protocol implemented in the JDBC driver and a native OCI access (provided you use up-to-date drivers, the 11.2 should be your first choice, even when using 10.x)
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •