Hello
I have simple mapping for updates. But the data flow throughput is less than 10 rows/sec.
When we do insert throughput is very high.
The table is optimized. We are updating just 2 column which doesn't have indexes on them.
When we create same table with same number of records (100000) on different database and ran the same transformation the target throutput is high enough 800 rows/sec.
Table doesn't have any partition and actual table has around 29 million rows.
table has around 40 columns, 1 primary key and have few indices.
We talked with DBAs and they told us that the database is already tuned.
The database server is staging server which has only 2 cpus and 4gb ram.
Any suggestion is highly appreciated.
Oscar W.
