This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC vs DB2 Export - Performance

 
Jaime Garcia
Ranch Hand
Posts: 38
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am working with DB2 and I have to export (2 times per day) a lot of information from a table (DB2 database). I Know that exist a Utility from DB2 (export utility) but, because I need to update the rows that I export, I would prefer to use JDBC (I think that I could have more control with JDBC) but I am worried about performance.
Dose any body Know if the export utility is faster (and better) than using JDBC ?
I Know that importing information is better to use the load Utility, but export information just read rows, so I think (hope) is mostly the same.
Thanks
 
Monty Ireland
Ranch Hand
Posts: 161
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
the answer is, it depends.
if you are doing a strait extract, export will be much faster.
if you need to extract data population A and update data population B
at the same time. then you have to code and application.
ie.
pgm begin
connect
select ...
update ...
terminate
pgm end
Try to use JDBC 2.0 with addBatch() / executeBatch() if possible.
Hope this helps
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic