--0-483097307-1106952878=:71727
Content-Type: text/plain; charset=us-ascii

>>Because the data is already in the buffer pool?
<<



I guess that's possible, but they are sequentially fetching every row from the table, so only when data is right next to each other on the same page, can they get the next row from the buffer pool, otherwise it will have to go to the disk to get the next row. At least that's what I'm thinking.


Obnoxio The Chav <obnoxio@serendipita.com> wrote:

Floyd Wellershaus said:
> 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 ?

Because the data is already in the buffer pool?

--

Bye now,
Obnoxio

"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

"I'm trying to see things your way, but I can't get my head up my ass"
- JCH

"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco

If anyone told you to be yourself they would be giving you bad advice.

I went to the airport to check in and they asked what I did because I
looked like a terrorist. I said I was a comedian. They said, "Say
something funny then." I told them I had just graduated from flying
school.

-- Ahmed Ahmed
sending to informix-list


========================
-<<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-483097307-1106952878=:71727
Content-Type: text/html; charset=us-ascii

<DIV>&gt;&gt;Because the data is already in the buffer pool?<BR>&lt;&lt;</DIV>
<P>&nbsp;</P>
<P>I guess that's possible, but they are sequentially fetching every row from the table, so only when data is right next to each other on the same page, can they get the next row from the buffer pool, otherwise it will have to go to the disk to get the next row. At least that's what I'm thinking.</P>
<DIV><BR><BR><B><I>Obnoxio The Chav &lt;obnoxio@serendipita.com&gt;</I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><BR>Floyd Wellershaus said:<BR>&gt; We are selecting 500,000 rows into a a cursor, with an order by, then<BR>&gt; processing those rows with by fetching them and doing work with them.<BR>&gt;<BR>&gt; I assume our tempdbspaces are being used for this.<BR>&gt; The performance gets better and better as the number of rows processed<BR>&gt; increases.<BR>&gt; Our developers want to know why this is happening ?<BR><BR>Because the data is already in the buffer pool?<BR><BR>-- <BR><BR>Bye now,<BR>Obnoxio<BR><BR>"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"<BR>- Coluche<BR><BR>"I'm trying to see things your way, but I can't get my head up my ass"<BR>- JCH<BR><BR>"Ogni uomo mi guarda come se fossi una testa di cazzo"<BR>- Marco<BR><BR>If anyone told you to be yourself they would be giving you bad advice.<BR><BR>I went to the airport to check in and they asked what I did
because I<BR>looked like a terrorist. I said I was a comedian. They said, "Say<BR>something funny then." I told them I had just graduated from flying<BR>school.<BR><BR>-- Ahmed Ahmed<BR>sending to informix-list<BR></BLOCKQUOTE><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-483097307-1106952878=:71727--
sending to informix-list