Hello!
On Tue, 18 Sep 2007, Biswadeep Chowdhury wrote:
"fetchall_arrayref" is just as slow for REF CURSORs because internally, OCI
still does a DB roundtrip for each row.
Running a test will illustrate the issue. Here is a result of a test run:
++++++++++++++++++++++++++++++++++++++++++++++++++
Fetched 2500 rows (select): [0.06174] secs.
Fetched 2500 rows (ref cursor): [5.40367] secs.
Fetched 2500 rows (ref cursor array-fetch): [0.631323] secs.
++++++++++++++++++++++++++++++++++++++++++++++++++
I know. I just mean that may be you should implement this
feature as fetchall_arrayref(), because there is no
DBD::Oracle's implementation of fetchall_arrayref().
Bye. Alex.
