Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows
| From: | Thies C. Arntzen | Date: | Wed, 23 May 2001 09:59:52 +0000 |
| Subject: | Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9564@lists.php.net to get a copy of this message | ||
On Tue, May 22, 2001 at 09:03:45PM +0200, snpe wrote:
>
>
> ---------- Forwarded Message ----------
> Subject: Re: [PHP-DB] OCIFetch performance problem with more rows
> Date: Tue, 22 May 2001 21:02:42 +0200
> From: snpe <snpe@verat.net>
> To: "Brian S. Dunworth" <brian@theprintinghouse.com>
>
>
> On Tuesday 22 May 2001 20:59, you wrote:
> > At 08:49 PM 5/22/01 +0200, snpe 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?