Hello, This patch speeds up both the regular fetch, as well as the fetchall_arrayref(). To me that seems better than ONLY speeding up fetchall_arrayref.
Biswa On 9/18/07, Alexander V Alekseev <[EMAIL PROTECTED]> wrote: > > 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. >
