On Wednesday 23 May 2001 12:21, you 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
I try, but it is same.
OCISetPrefetch increase 'fetch memory' , but I think that is problem with
array.Function oci_fetch have parameter 'nrows', but this is always 1
(possible that this is TODO).
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]