naveen kumar saharan created NIFI-7086:
------------------------------------------
Summary: oracle db read is slow (for me its bug)
Key: NIFI-7086
URL: https://issues.apache.org/jira/browse/NIFI-7086
Project: Apache NiFi
Issue Type: Bug
Environment: nifi 1.8.0
Reporter: naveen kumar saharan
I am not able to fetch oracle db for 1 billion record table. It is taking too
much time(17 hours).
I tried creating queries based on dates using executesql -> generatetablefetch
-> executesql to parallel execution
small tables also performs slow as compared to python database table fetch
program around 20 times slower. This is very disapppointing.
querydatabasetable runs only on primary node with , if i increase thread it
give duplicate data.
Then what is the use of concurrent thread?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)