Re: Perl calls to Oracle vs SQL*Plus sessions from a shell script

From: Ron Reidy <rereidy_at_uswest.net>
Date: Fri, 28 May 1999 23:48:42 -0600
Message-ID: <374F7FB9.5C846180@uswest.net>

monsri_at_my-deja.com wrote:

> Hi,
>
> I just would like to know what is the most performant
> solution: let's assume you run EXACTLY the same SQL
> statements, what will be the best and the quickest ?
>
> Call Oracle from a Perl script, or execute SQL*Plus
> sessions from a shell ???
>
> Has somebody already experienced tests to check what
> is the most efficient ? For which reasons ??
>
> Thanks a lot for any enlightenments !!
>
> Regards,
> Monsri.
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---

Depends on what you are trying to do.

When executing SQL*Plus from the shell, you create a sub-process. When you use perl with DBI/DBD, there is no sub process created.

--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C. Received on Sat May 29 1999 - 00:48:42 CDT