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...
- Brian
-------------------------------------
Brian S. Dunworth
Sr. Software Development Engineer
Oracle Database Administrator
The Printing House, Ltd.
(850) 875-1500 x225
<[EMAIL PROTECTED]>
-------------------------------------
--
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]