[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dbi-dev
Subject:    RE: DBD::Oracle and VARRAY access
From:       "Wilt, Paul" <pwilt () xanedu ! com>
Date:       2000-12-01 14:14:25
[Download RAW message or body]




Dean:

Can you put your source code for the modifications you made to the
Teradata driver in some place accessible so that I can try to model
my changes on what you have already done?

Thanks
Paul E Wilt 
Principal Software Engineer
____________________________________________________
XanEdu, Inc. ( a division of Bell+Howell Information&Learning)
http://www.XanEdu.com
mailto:pwilt@XanEdu.com
mailto:pwilt@umi.com
300 North Zeeb Rd			Phone: (734) 975-6021  (800)
521-0600 x6021
Ann Arbor, MI 48106		Fax:    (734) 973-0737
____________________________________________________



-----Original Message-----
From: Wilt, Paul 
Sent: Wednesday, November 29,2000 5:20 PM
To: 'Dean Arnold'; Wilt, Paul; Dittmar, Daniel; Tim Bunce
Cc: dbi-dev
Subject: RE: DBD::Oracle and VARRAY access


Over the next few days I hope to have time to do the same for Oracle.

Thanks
Paul E Wilt 
Principal Software Engineer
____________________________________________________
XanEdu, Inc. ( a division of Bell+Howell Information&Learning)
http://www.XanEdu.com
mailto:pwilt@XanEdu.com
mailto:pwilt@umi.com
300 North Zeeb Rd			Phone: (734) 975-6021  (800)
521-0600 x6021
Ann Arbor, MI 48106		Fax:    (734) 973-0737
____________________________________________________



-----Original Message-----
From: Dean Arnold [mailto:darnold@earthlink.net]
Sent: Wednesday, November 29,2000 5:01 PM
To: Wilt, Paul; Dittmar, Daniel; Tim Bunce
Cc: dbi-dev
Subject: Re: DBD::Oracle and VARRAY access





FYI...I've implemented a driver-specific version of the
bind_param_array() in DBD::Teradata along the lines we've discussed thus
far,
and ran a quick test comparing the row-by-row bind/execute method vs.
the array-of-rows bind/execute method.

Environment:
Client: AMD 380Mhz laptop (Win98, ActiveState 5.6.0)
Server: 800 MHz PIII (WinNT 4.0)
100 Mbps Ethernet connection.
Loading 100,000 rows, 2 fields each (1 INTEGER, 1 CHAR(100)).

Total time for row-by-row bind:    102 secs
Total time for array-of-rows bind (280 rows per bind): 40 secs.

All other environmental factors were identical. So there appears to be
a definite benefit to using a bulk operation. I hope to check
bind_col_array() vs. bind_col() by next week.

Regards,
Dean Arnold



----------------------------------------------------------------------------
--
DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/
To unsubscribe from this list, please visit:
http://www.isc.org/dbi-lists.html
If you are without web access, or if you are having trouble with the web
page,
please send mail to dbi-dev-request@isc.org with the subject line of:
'unsubscribe'.
----------------------------------------------------------------------------
-- 


------------------------------------------------------------------------------
DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/
To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html
If you are without web access, or if you are having trouble with the web page,
please send mail to dbi-dev-request@isc.org with the subject line of:
'unsubscribe'.
------------------------------------------------------------------------------ 

[prev in list] [next in list] [prev in thread] [next in thread]