I can test on Windows native (MS Visual Studio.NET 2003), Windows Cygwin, and Whitebox Linux (an RHEL4 clone), with some combinations of 9.2, 10.2 and Oracle XE. I'm still setting things back up again on the Windows side after a hard drive crash, so this is a bit limited at the moment. I may also be able to do some limited testing on Solaris at work, but only where it's related to the process I mentioned that would benefit from array binding.
I have a script that does batch builds and tests under various OS, Oracle client and NLS_LANG combinations, which I've run for the last couple of releases of DBD::Oracle; if you're interested I can tidy that up and publish it. -- Andy Hassall :: [EMAIL PROTECTED] :: http://www.andyh.co.uk http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool -----Original Message----- From: John Scoles [mailto:[EMAIL PROTECTED] Sent: 07 June 2006 17:10 To: [EMAIL PROTECTED] Cc: [email protected] Subject: Re: Testing DBD::Oracle array interface Thanks Andy that is great. I am finding a few things as I test on other boxes as well (Lunix and windows). Would you be so kind as to send me details on your test rig that is one area where my resources as a little limited. Cheers. ----- Original Message ----- From: "Andy Hassall" <[EMAIL PROTECTED]> To: "John Scoles" <[EMAIL PROTECTED]> Cc: <[email protected]> Sent: Wednesday, June 07, 2006 11:29 AM Subject: Re: Testing DBD::Oracle array interface > > 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 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. > > I'm very interested in this, but for a slightly different reason - I > don't have huge data volumes, just hundreds to maybe a few thousand rows > at a time, but in one particular process I am having to connect over a > medium latency (120ms) transatlantic network link. The network overheads > for single rows inserts are killing performance here. > > Tried compiling on Cygwin to start with; this failed as an earlier change > in LOB support didn't add some lines to oci.def - patch attached to fix > it (this applies to both trunk and array branch). > > Have also now compiled and tested on Solaris; results from a simple test > inserting batches of 1000 rows to a remote database: > > Rate singlerow arrayinterface > singlerow 4.76/s -- -87% > arrayinterface 35.7/s 650% -- > > So that looks quite promising. > > thanks, > -- > Andy Hassall / <[EMAIL PROTECTED]> / <http://www.andyh.co.uk> > <http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool
