Re: [cx-oracle-users] Loop over Cursor stalls for several minutes

[Grzegorz D. <gol...@wp...>]

> It greatly depends on the execution plan.
> If Oracle decides that the first rows can be returned quickly, it will
> do so;
> Now if the fetch array size is 100, the next rows will be retrieved/
> computed during the fetch operations.

I still think that's not the case. The array size is large enough to grab
all 1597 rows at once. Secondly, I also ran the same SQL code from SQL
Developer and didn't witness this kind of lag. Neither did it happen in the
legacy script nor in a bare-bone Python script I've made for testing (just
displaying fetched rows to console).

But thanks anyway. If anyone has other ideas, please let know.

- Grzegorz