Bill Haverberg wrote:
>
> I have a perl module I created that interfaces with Oracle via an
> overengineered here file wrapping a sqlplus session which I keep open,
> allowing me to continuously send queries to Oracle and retrieve
> results without having to constantly open and close a sqlplus session
> (I know about PerlDBI but for administrative reasons we can't install
> it). I prefer doing it this way becaue of Perl's rich set of language
> features as compared to PL/SQL.
>
> My question is am I taking a massive performance hit doing this? Is
> PL/SQL inherently going to be faster then the perl approach? I realize
> for triggers and such I'll have to stay with PL/SQL but has anyone
> done a comparison of PL/SQL performance vs other embedded approaches?
>
> Thanks.
PL/SQL will almost always be faster, because the entire PL/SQL block is
handled as if it were 1 SQL statement.
--
Ron Reidy
Oracle DBA
Received on Mon May 20 2002 - 07:37:20 CDT
