RE: Embedding perl in Oracle

How well does MySQL scale. How does it handle parallel direct inserts? Does it do it better than the Oracle OCI interface. We've got an Oracle experiment running now for our channel archive data, real time data from sensors monitoring the accelerator. We haven't switched off the old write to linked files method, and won't for a year.

However, the proposed NLC, Next Linear Collider, will need to capture this data at a rate of 10,000 gigabytes!! a second. Of course one might question the utility of collecting monitoring data at a petabyte a second. If the project is approved, people have five years to come up with the why and how.

Perhaps I should recommend they use MySQL :)     

-----Original Message-----
Sent: Wednesday, December 05, 2001 9:31 AM To: Multiple recipients of list ORACLE-L

Tim,

That sounds rather interesting, as the impression that MySQL users sometimes give is that they're perfectly happy with MySQL and don't have any need to move to Oracle or anything else.

Any particular features of Oracle that the owners feel they need, or is it a move to satisfy investors/auditors/etc.?

Jared

                                                                                       
                             
                    Tim Bunce                                                          
                             
                    <Tim.Bunce_at_pob       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>        
                    ox.com>              cc:                                           
                             
                    Sent by:             Subject:     Re: Embedding perl in Oracle     
                             
                    root_at_fatcity.c                                                     
                             
                    om                                                                 
                             
                                                                                       
                             
                                                                                       
                             
                    12/05/01 03:30                                                     
                             
                    AM                                                                 
                             
                    Please respond                                                     
                             
                    to ORACLE-L                                                        
                             
                                                                                       
                             
                                                                                       
                             

On Tue, Dec 04, 2001 at 08:26:52PM -0500, Thomas A.Lowery wrote:
> My office mate (cc'd) also set this up to demo the process. I'm
> considering testing out the possibility of using an Oracle view on
> top of function that calls a extproc_perl to a MySQL database.

I imagine that'll be at least an order of magnitude slower than using the Oracle ODBC Gateway and MyODBC to do the same thing. I'll also be read-only.

I'm due to be working on setting up a Oracle ODBC Gateway and MyODBC for a production system soonish. It's part of a strategy to simplify migration from MySQL to Oracle.

Tim.

> Tom
>
> On Wed, Dec 05, 2001 at 12:55:31AM +0000, Tim Bunce wrote:
> > On Tue, Dec 04, 2001 at 01:45:46PM -0800, Jared.Still_at_radisys.com
wrote:
> > >
> > > Of course, you can already call Perl from oracle via extproc_perl.
> > >
> > > I've done it, it works. Be aware that setting it up is not trivial,
> > > as the documentation is somewhat incomplete.
> > >
> > > That is being remedied however...
> > >
> > > http://www.cpan.org/modules/by-authors/Jeff_Horwitz/
> >
> > Oh, very interesting. Thanks.
> >
> >

http://www.cpan.org/modules/by-authors/Jeff_Horwitz/extproc_perl-0.93.readme

> >
> > I'll take a look and add that to my Perl Whirl talk.
>
> --
> Thomas A. Lowery
> See DBI/FAQ http://tlowery.hypermart.net
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Bunce
  INET: Tim.Bunce_at_pobox.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).