At 08:49 PM 5/22/01 +0200, snpe wrote:
>         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

PHP Database Mailing List (
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