On Wed, Aug 08, 2001 at 03:43:05PM -0400, Jeff Urlwin wrote:
> Now I remember why I shelved it for a bit.
>
> As I recall, it required changes to DBI. Those need to be coordinated with
> Tim, as I can't really update DBD::ODBC without the corresponding changes to
> the DBI.
Actually you don't - just add the functions and call them via $h->func(...,'funcname').
I'd rather not change the official spec till we've got a couple of
working implementations we can play with. I'd then also want to try implementing
fallback behaviour in the DBI for driver that don't support the new methods.
Tim.
> Can we discuss the changes to the DBI spec and how the array binding is
> implemented? I believe Dean is proposing three new functions:
>
> $rv = $sth->bind_param_array($p_num, \@bind_value_ary);
> $rv = $sth->bind_param_array($p_num, \@bind_value_ary, $bind_type);
> $rv = $sth->bind_param_array($p_num, \@bind_value_ary, \%attr);
>
> As I, honestly, haven't been keeping up with the DBI spec, I can't tell
> where DBI was going with this.
>
> Jeff
>
>
> > -----Original Message-----
> > From: Dean Arnold [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, August 08, 2001 11:00 AM
> > To: Jeff Urlwin
> > Subject: Fw: Call for testers: Array binding via DBD::ODBC
> >
> >
> > Here's the original msg w/ attachment...
> >
> > Glad to see you're still "on the bus" with this...
> >
> >
> > Regards,
> > Dean Arnold
> >
> > ----- Original Message -----
> > From: "Dean Arnold" <[EMAIL PROTECTED]>
> > To: "Jeff Urlwin" <[EMAIL PROTECTED]>
> > Sent: Monday, January 29, 2001 4:54 PM
> > Subject: Re: Call for testers: Array binding via DBD::ODBC
> >
> >
> > > I've attached a ZIP file with several source files:
> > >
> > > The DBI.pm includes the changes for the DBI layer, and has some POD
> > > updates describing the interfaces.
> > >
> > > The ODBC.xsi file has the DBI-to-DBD::ODBC translation layer
> > > stuff in it.
> > >
> > > The dbdimp.c file has the actual implementation code in it, and
> > > dbdimp.h has some updates to the common data structures.
> > >
> > > bulkapitst.pl is a little test script to compare row-at-a-time vs.
> > > array binding.
> > >
> > > BTW I've had a chance to test this with Oracle's ODBC
> > > driver, it seems to get about a 10x thruput improvement
> > > for INSERTs, and about 2x for SELECT.
> > >
> > > Also be advised that I'm not an XSUB guru, so some of
> > > my implementation may make you cringe; any comments
> > > or questions are welcome.
> > >
> > > Regards,
> > > Dean Arnold
> > >
> > >
> > > ----- Original Message -----
> > > From: "Jeff Urlwin" <[EMAIL PROTECTED]>
> > > To: "Dean Arnold" <[EMAIL PROTECTED]>; "DBI-users"
> > <[EMAIL PROTECTED]>
> > > Sent: Monday, January 29, 2001 3:21 PM
> > > Subject: RE: Call for testers: Array binding via DBD::ODBC
> > >
> > >
> > > > Dean,
> > > >
> > > > Sorry, I've been out of the loop and on vacation the last week.
> > > >
> > > > Please send proposed patches to me. I anticipate having more
> > time to work
> > > > on DBD::ODBC shortly as I am leaving my current job to "go
> > out on my own".
> > > > My current job has been a timesink, so this should be
> > interesting. I have
> > > > an upcoming release for DBD::ODBC WRT bind_param_inout, but I
> > haven't been
> > > > able to get it to work on Oracle yet, so I haven't released it.
> > > >
> > > > Jeff
> >
> >