Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows

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 > way) 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).