Re: Pro*C newbie : need help with fetch on remote DB

Pluton wrote:
>
> Hello world.
>
> I would like to know if the "FETCH" statement is slow when executing on
> remote DB. Connecting via SQL*Net v1, TWO_TASK and ORACLE_SID env variables
> are set correctly but when a query results more than 20 lines, it is
> terribly slow....

I would suspect that it is actually the contents of your SELECT statement that is slow. Are you querying on an indexed column? Have you created a wicked outer join? SQL*NET is _very_ fast over a LAN. If you see problems as your result set increases, you should try to optimize your SELECT statement.

> I use "make -f proc.mk sample10.pc" to compile the source. Do I need to
> set some parameters to enhance performance on FETCH ?
>
> Many thanks for your help.

-- 
Jeffery Cann
Fairway Systems, Inc.
Senior Software Engineer