On Tue, May 22, 2001 at 09:03:45PM +0200, snpe wrote:
> 
> 
> ----------  Forwarded Message  ----------
> Subject: Re: [PHP-DB] OCIFetch performance problem with more rows
> Date: Tue, 22 May 2001 21:02:42 +0200
> From: snpe <[EMAIL PROTECTED]>
> To: "Brian S. Dunworth" <[EMAIL PROTECTED]>
> 
> 
> On Tuesday 22 May 2001 20:59, you wrote:
> > At 08:49 PM 5/22/01 +0200, snpe wrote:
> > >Hello,
> > >         I have performance problem with OCIFetch (and OCIFetchInto, too)
> > > when query return more rows.Same query from sqlplus is more fastest (more
> > > rows is worse then less rows)
> >
> >    Are the columns you're fetching included in an Oracle index?  Without an
> > appropriate index, your SQL statement is probably doing a full table scan,
> > which can be *very* time-consuming...
> 
> Hello,
>       Indexes aren't  problem.I use php and sqlplus with same tables.
> Sqlplus is faster.

    by what amount?

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to