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

> > > >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: rsokolowski@wp-sa.pl / \ -----------------------------------------------------------------/____\-----