---------- Forwarded Message ----------
Subject: Re: [PHP-DB] OCIFetch performance problem with more rows
Date: Tue, 22 May 2001 21:02:42 +0200
From: snpe <[EMAIL PROTECTED]>
To: "Brian S. Dunworth" <[EMAIL PROTECTED]>
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
-------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]