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
