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]

Reply via email to