On Wed, May 23, 2001 at 12:21:08PM +0200, Remigiusz Sokolowski 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?
>
> May be You could try to use OCISetPrefetch - it is not documented, but
> there is short note at www.php.net from somebody about it.
> I can say, it speeds things up very much (if You wanna more than 1 row)
> Btw. anybody knows why it is not documented (I mean "hidden" in some
> way)
nobody has gotten around documenting it.
tc
--
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]
