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]