Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows
| From: | snpe | Date: | Tue, 22 May 2001 19:03:45 +0000 |
| Subject: | Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9537@lists.php.net to get a copy of this message | ||
---------- 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.
regards
-------------------------------------------------------