Re: Loop over Cursor stalls for several minutes

> 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


------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter