So I’m fetching data from large tables. I’m using fetchmany to get 100,000 rows at a time. However, during my export, I will occasionally get a network disconnect, or need to stop the process for one reason or another.

I was wondering if there is a way to perform a fetchmany after a certain point. For instance, if I have a table with 1 Million rows. The program stopped in the middle and I can see I got the first 500,000 rows. Is there a way I can tell my fetchmany to start after row 500,000?