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