Hi Shreedhar and the rest of the dev list I have managed to add support for the Oracle Array Interface in DBD::Oracle. The original code comes from an old patch that Kristian Nielsen had created a while back but never seem to get into the to trunk.
I am just in the test design phase right now. (I want to do some benchmarks for large inserts) but I figure it is stable enough that I would ask for a little help from the list on testing this patch. To be on the safe side I created a new branch on the SVN tree so the code for this patch can be found at http://svn.perl.org/modules/dbd-oracle/branches/array I was hoping someone could do a benchmark type test on loading many thousand or millions or records, as this seem to be what people want to use the interface for. Cheers John Scoles ----- Original Message ----- From: "Shreedhar Natarajan" <[EMAIL PROTECTED]> To: "John Scoles" <[EMAIL PROTECTED]> Sent: Monday, May 29, 2006 10:03 AM Subject: Re: oracle array interface > Hi John, > > I am happy to do the testing. I was about to give up on perl/oracle. I deal > with large sets of data. I appreciate your working on it. > > In the meantime, to keep me productive on my research, I am considering > using java and calling java from perl. Any thoughts on that? > > Thanks, > Shreedhar > > > At 09:51 AM 5/29/2006 -0400, you wrote: > >I am sort of working on it right now. Slowly of course. The current one > >works but all it does is iterate over you array and execute your statements. > >It makes your code tidy but does not go any faster that doing the iteration > >yourself. > > > >Look for a patch for Array Interface sometime within the next two months. > > > >It would be great if you could do some testing with it as well > > > >Cheers. > >John Scoles > > > >----- Original Message ----- > >From: "Shreedhar Natarajan" <[EMAIL PROTECTED]> > >To: <[email protected]> > >Sent: Monday, May 29, 2006 9:25 AM > >Subject: oracle array interface > > > > > > > Hi, > > > > > > I saw on the web that the Oracle array interface has not been implemented > > > properly. I am new to DBI. Has the implementation been made more > >efficient? > > > > > > Thanks, > > > Shree > > > > > > > >
