> > > >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)
--
-------------------------------------------------------------------/\------
Remigiusz Sokolowski e-mail: [EMAIL PROTECTED] / \
-----------------------------------------------------------------/____\-----
--
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]
