--0-975139384-1106928503=:17286
Content-Type: text/plain; charset=us-ascii

We are selecting 500,000 rows into a a cursor, with an order by, then processing those rows with by fetching them and doing work with them.

I assume our tempdbspaces are being used for this.
The performance gets better and better as the number of rows processed increases.
Our developers want to know why this is happening ?
Any ideas ?

Thanks,
floyd


========================
-<<Floyd Wellershaus>>-
Database Administrator
Unix Administrator

email: fwellers@yahoo.com
Work: 703-733-4126
Pager: 703-705-9241
Email Pager: 7037059241@my2way.com
Home: 703-430-0805
Cell: 703-477-6045
========================


--0-975139384-1106928503=:17286
Content-Type: text/html; charset=us-ascii

<DIV>We are selecting 500,000 rows into a a cursor, with an order by, then processing those rows with by fetching them and doing work with them.</DIV>
<DIV>&nbsp;</DIV>
<DIV>I assume our tempdbspaces are being used for this.</DIV>
<DIV>The performance gets better and better as the number of rows processed increases.</DIV>
<DIV>Our developers want to know why this is happening ?</DIV>
<DIV>Any ideas ?</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanks,</DIV>
<DIV>floyd</DIV><BR><BR><DIV>
<DIV>========================<BR>-&lt;&lt;Floyd Wellershaus&gt;&gt;-<BR>Database Administrator<BR>Unix Administrator</DIV>
<DIV><BR>email:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ;&nbsp;&nbsp;&nbsp;&nbsp; <A href="mailto:fwellers@yahoo.com">fwellers@yahoo.co m</A><BR>Work:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb sp;&nbsp;&nbsp;&nbsp; 703-733-4126</DIV>
<DIV>Pager:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb sp;&nbsp;&nbsp; 703-705-9241 </DIV>
<DIV>Email Pager: <A href="mailto:7037059241@my2way.com">7037059241@my2 way.com</A></DIV>
<DIV>Home:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp; 703-430-0805</DIV>
<DIV>Cell:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;703-477-6045<BR>========================</DIV></DIV>
--0-975139384-1106928503=:17286--
sending to informix-list

Floyd Wellershaus wrote:

Please do not post MIME or multiple display types.

> We are selecting 500,000 rows into a a cursor, with an order by, then processing those rows with by fetching them and doing work with them.
>
> I assume our tempdbspaces are being used for this.
> The performance gets better and better as the number of rows processed increases.
> Our developers want to know why this is happening ?
> Any ideas ?

Please be more specific. What do you mean by 'The performance gets better
and better as the number of rows processed increases.'? Do you mean that if
the temp table is larger performance improves? Or that after processing
10000 out of 500000 speed increases then increases again as you process the
20000th row etc?

Art S. Kagel