I am running 2 queries, where the 1st query output will act as a input to the 2nd query , and I need to loop through all the records from the oracle db , assume the response from db is around thousands of records , where I need to loop through each and every record (because requirement is something like that)
Do we have any solution , something like fetch the records by batches [ first fetch 100 records and next fetch another 100 records ]
because If I try to hit my API, because of looping , it is taking too much time to execute my queries and logic and finally when i hit the API from postman / using curl , I am getting a timeout error from curl and socket hang up error from postman.
Do we have any other solution ?
Please help on the above.