Re: Embedding perl in Oracle

On Wed, Dec 05, 2001 at 03:00:19PM -0800, MacGregor, Ian A. wrote:
> How well does MySQL scale.

This well: |<----------->|

:)

> How does it handle parallel direct inserts?

It doesn't. But then it's faster than Oracle to start with.

Oracle will _always_ be able to beat MySQL at the top end. But MySQL can (nearly) always beat Oracle at the bottom end. It's in the middle that things get tricky and many other issues come into play.

Oracle is much better at spreading IO over multiple disks with fine granularity, and much better at data caching (MySQL basically only does index caching - part of it's approach to reliability.)

> Does it do it better than the Oracle OCI interface.

Better? Probably not. But there's a sufficent API and, of course, a Perl DBI driver :)

> 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 :)

I'd certainly recommend that they look at it. It is *free* after all. That means that money you save by not buying Oracle licences can go into more hardware :)

I really don't want to get into any big debate about the pros and cons of MySQL. It's certainly has it's faults, just like Oracle. Looked at with an Oracle mindset it'll probably look too basic. But as with all such issues, people need to try it for themselves.

Tim.

> -----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).

-- 
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).