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

[Amaury F. d'A. <ama...@gm...>]

2013/4/19 Grzegorz Dąbkowski <gol...@wp...>

> > Could it be the case that the initial time might be in setting up and
> > executing the query?  Are there joins, order bys, etc?
>
> Wouldn't that affect cursor.execute() rather than the iteration?


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.

-- 
Amaury Forgeot d'Arc