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

[Quoted]  Thanks for the answer but I'm sure this is not a SQL problem. The SELECT statement is "select * from table_name where rownum<20".... approx. less than 1 second with local DB and more than 20 seconds for the same DB and table with remote DB !
The problem is that I don't know how to use full dynamic SQL with host arrays. I can't find a sample to help me.

Thanks again!

Jeffery Cann <jcann_at_fairway.com> a écrit dans l'article <35A4FB54.D7EAEB36_at_fairway.com>...
> 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
>
Received on Wed Jul 15 1998 - 13:40:39 CEST