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@pob To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
ox.com> cc:
Sent by: Subject: Re: Embedding perl in Oracle
[EMAIL PROTECTED]
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, [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
