Re: OCIFetch performance problem with more rows
| From: | Brian S. Dunworth | Date: | Tue, 22 May 2001 18:59:04 +0000 |
| Subject: | Re: OCIFetch performance problem with more rows | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9536@lists.php.net to get a copy of this message | ||
At 08:49 PM 5/22/01 +0200, snpe wrote:
Hello,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 <brian@theprintinghouse.com> -------------------------------------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)