0
2

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

Pentaho Data Integration データ抽出高速化

Last updated at Posted at 2019-09-20

接続タイプ:Oracle
アクセス:Native(JDBC)

上記の場合、以下のパラメータで調整。よく度忘れするのでメモ。
defaultRowPrefetch

自分の環境では、以下の通り改善。
3.5分で約2000万件のデータをCSV出力。
デフォルト(指定なし) = 3000r/s
2,0000設定時 = 7,0000r/s

image.png

0
2
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
2

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?