Re: Cursor problem

From: Roger Snowden <snowden_at_NOT.com>
Date: Tue, 22 Dec 1998 02:29:37 GMT
Message-ID: <367F033C.441EDA66@NOT.com>

Boa Noite, Marco-

No, you are not perfectly clear. Sorry. Generally, retrieving more rows will increase retrieval time, won't it? Does the Pro*C program execute on one of the server hosts? Is there a client workstation in the way? Are you opening a huge cursor with zillions of rows? Are you using array fetches? Is there competition for network or machine resources? How much is much?

Roger

Roger Snowden
Sr. Systems Engineering Specialist
Oracle Corporation
rsnowden_at_NOTus.oracle.com <-- to reply, remove the obvious

Marco Ribeiro wrote:
>
> Hi,
>
> We are having a problem with a cursior in a Pro*C program. We select
> some records from a local database and then we insert them in a central
> database, everything goes smoothly if the query returns less than 350
> records but when we get more records we process becomes very slow.
>
> I hope I made myself clear.
>
> Any ideas ?
>
> Thanks in advance.
>
> Marco Ribeiro
Received on Mon Dec 21 1998 - 20:29:37 CST