Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows
| From: | Thies C. Arntzen | Date: | Wed, 23 May 2001 10:41:53 +0000 |
| Subject: | Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9566@lists.php.net to get a copy of this message | ||
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