Re: Loop over Cursor stalls for several minutes

2013/4/19 Grzegorz Dąbkowski <[email protected]>

> > 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

------------------------------------------------------------------------------
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

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users