Unanswered: oracle - odbc to jdbc bridge- efficiency?
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?
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).
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.