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)

Reply via email to