Re: Oracle and PHP with Cursors
- From: DA Morgan <damorgan@xxxxxxxxx>
- Date: Fri, 16 Nov 2007 16:57:29 -0800
Björn Wächter wrote:
Hi all,
we are using Oracle and PHP for a Web application.
We are using ref cursors to return data from oracle
to php.
PROCEDURE GetData(
p_form IN VARCHAR2,
crs_data OUT Usertype.ref_cursor
)
AS
...
BEGIN
....
OPEN crs_data FOR v_sql;
END;
CREATE OR REPLACE PACKAGE usertype AS
TYPE ref_cursor IS REF CURSOR;
END usertype;
We are facing the problem that retrieving the data over
the cursor is quite slow because we see in the trace that
every row is request with one call to oracle. We enabled
prefetching in PHP but as fare as we know this is not
possible for cursors. We need the flexibility of cursors
to be able to return different numbers of columns in each
request.
Any ideas how we can solve this problem?
We read something about scrollable cursors. Is this a way?
Thanks Björn
Oracle version number.
DDL would be helpful.
Information such as the number of rows being returned useful.
Is there a WHERE clause anywhere in sight?
Has the statement been tuned? How? With DBMS_XPLAN?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.
- References:
- Oracle and PHP with Cursors
- From: Björn Wächter
- Oracle and PHP with Cursors
- Prev by Date: Re: OPTIMIZER_HINT, FIRST_ROWS, and MAX
- Next by Date: Re: where to set the Oracle timeout? ORA-02396: exceeded maximum idle time
- Previous by thread: Oracle and PHP with Cursors
- Next by thread: What is the most widely used RAID type for Oracle databases?
- Index(es):
Relevant Pages
|
