[ https://issues.apache.org/jira/browse/NIFI-7086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Matt Burgess resolved NIFI-7086. -------------------------------- Resolution: Not A Problem > 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: Improvement > Environment: nifi 1.8.0 > Reporter: naveen kumar saharan > Priority: Minor > > 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.20.10#820010)