Zoran,
Even though it sounds like it would be hard to use Perl and sqlldr =
together, it is not. Named pipes have been around for (it seems) =
decades and command piping (putting one program's STDOUT onto another =
program's STDIN) has been around forever. After you get the hang of it, =
you will be amazed at what you can do with the combination of the your =
favorite shell and Perl.
I have not used execute_array, but you may also find that no matter how =
hard you try, you will not beat sqlldr's speed for bulk inserts.
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Martic Zoran
Sent: Thursday, March 10, 2005 9:14 AM
To: oracle-l_at_freelists.org
Subject: RE: Perl again
Thanks Ron,
I am checking the net at the moment, to find out more
things aboput execute_array, some script to try it.
That is looking a little bit too complex for me :)
Also it is very hard to control what is happened to
the DML and such things.
The intergation is the most problematic area in all
projects, even simple like Perl + SQL*Loader :)
Thanks,
Zoran
- "Reidy, Ron" <Ron.Reidy_at_arraybiopharma.com> wrote:
> This question would better posed to Tim Bunce or to
> dbi-users_at_perl.org. I think there is work on array
> processing, or at least the plan to do so soon..
>=20
> However, if you want bulk operations, look at
> sending the data to a named pipe which is the input
> to SQL*Loader.
>=20
> -----------------
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>=20
>=20
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
> Martic Zoran
> Sent: Thursday, March 10, 2005 1:49 AM
> To: oracle-l_at_freelists.org
> Subject: Perl again
>=20
>=20
> Hi all,
>=20
> I have a simple question about Perl that I found
> when
> I was testing the speed of Perl doing Oracle
> transactions. The main reason for testing it was
> that
> my company has the internal script language similar
> to
> Perl (do not ask me why is it invented, not me :)
> and
> I wanted it to compare the speed. Two targets:
> 1. Is our scirpting language slower then Perl?
> 2. Is Perl API nicer then ours and what we can do
> about it?=20
> The second was of course, Perl API is great and
> smart,
> but the first one !!!
>=20
> Back to question the question:
>=20
> Why Perl does not have bulk (array) DML supported?
>=20
> If I maybe missed it in the docs or somehow please
> let
> me know.
>=20
> Perl will be impressive high-performance Oracle
> client/server toolkit with this kind of
> fucntionality.
>=20
> Because we have all advanced OCI features
> implemented
> (array DML, ...) in our internal scripting language
> we
> could not believe it that Perl supported by so many
> people is without it.
>=20
> Any comment is welcome.
>=20
> Thanks,
> Zoran Martic
> Oracle Mine Worker
>=20
>=20
>=20
>=20
>=20
> =09
> __________________________________=20
> Do you Yahoo!?=20
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/=20
> --
> http://www.freelists.org/webpage/oracle-l
>=20
> This electronic message transmission is a PRIVATE
> communication which contains
> information which may be confidential or privileged.
> The information is intended=20
> to be for the use of the individual or entity named
> above. If you are not the=20
> intended recipient, please be aware that any
> disclosure, copying, distribution=20
> or use of the contents of this information is
> prohibited. Please notify the
> sender of the delivery error by replying to this
> message, or notify us by
> telephone (877-633-2436, ext. 0), and then delete it
> from your system.
>=20
>=20
=09
__________________________________=20
Do you Yahoo!?=20
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/=20
--
http://www.freelists.org/webpage/oracle-l
This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 10 2005 - 12:52:38 CST
