Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    7

    Question Unanswered: oracle - odbc to jdbc bridge- efficiency?

    Hi,

    I have a query, wondering if anyone can shed some light on it.
    we are using a simple java unload script to extract data from an oracle database. This goes through odbc and the standard jdbc bridge.
    This script can be called from anywhere - but is it more efficient to run this on the source server where the db resides and then move the extract file as opposed to calling the script on the target server where it will be extracted directly to there?

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    It probably would be more efficient to run it on the database server and move the file to the target server after it finishes. You would also probably get a good improvement in performance if you rewrite your app to use the Oracle thin java driver (or OCI if you can install the client).

    Alan

  3. #3
    Join Date
    Sep 2003
    Posts
    7
    Thanks for the insight Alan.

    For the moment performance from running it on the target server seems good enough for us and is easier to maintain because we don't need shares etc. on other servers. Also, I should have mentioned that we are also using this script to extract from SQL Server DBs so we'll probably stick with the generic odbc-jdbc brigde as opposed to using db specific clients.

Posting Permissions

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