In my scenario, as shown in the picuture, 'ExecuteSQL' processor is producing millions of records, and hence NIFI is running out of memory and getting stuck in the queue and becoming slow.I have made all the possible configurations in the config file, but not helpful. Hence i wanted to restrict the file flow as below, to avoid this situation.
I have 'ExecuteSQL' processor, as show in the picture, which takes input from the incoming flowfile. My requirement is to restrict the flow of the files in queue one-by-one. i.e, incoming only one flowfile to 'ExecuteSQL' processor and allowing it to finish the complete process of nifi flow and once it is done, allowing the next file in the incoming queue of 'ExecuteSQL' processor .
Is there a way to do that?