Note: As of version 3.2.3gamma Mysql Supports Sub-Selects.
.:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
Systems & Network Administrator :: Programmer
[ phone - 208.343.3110 ][ pager - 208.387.9983 ]
----- Original Message -----
From: "Scott Gerhardt" <[EMAIL PROTECTED]>
To: "Ann Ricchiazzi" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, January 22, 2001 12:10 PM
Subject: RE: mySQL vs Oracle
> Hello Ann,
>
> The answer to you question depends on how you plan to use the database
(i.e.
> financial trancactions, serving data on the web etc.) as well as financial
> considerations. MySQL is free and Oracle is expensive.
>
>
> Here are some questions you should answer:
>
> 1.) Do you need full Transaction support (commit roll-back)?
> 2.) Do you need subselect and union queries?
> 3.) Do you need Triggers and Stored Procedures?
> 4.) Do you absolutely need Foreign Key support?
>
> If you anwered YES to any of the above go with Oracle, Sybase, Frontbase,
> Openbase etc. otherwise, MySQL is an excellent choice. MySQL is very fast
> and probably faster than Oracle in most cases but I have no documented
proof
> (Oracle doesn't like having their benchmarks published).
>
> I know this isn't a definite answer and you are on a tight deadline. Hope
> this helps just the same.
>
>
> ___________________________________
>
> Scott A. Gerhardt P.Geo.
> Gerhardt Information Technologies
> [EMAIL PROTECTED]
> ___________________________________
>
>
>
>
>
>
>
>
>
>
> > I am trying to choose between mySQL and Oracle for a Linux server. My
> > specific questions are:
> >
> > 1) Will mySQL handle 3000 hits/day well?
> > 2) Does mySQL handle multi-media file formats? For example, if I want to
> > store audio clips, or Flash movie clips, or PowerPoint presentations,
> > can I do so?
> >
> > We make the decision this decision at 3:00 today. Your advice will be
> > most helpful.
> > Thanks,
> > Ann
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
