John,
I don't think anyone can say for sure which is 'better'. MySQL is used in a
different kind of environment than Oracle. Oracle is designed for an
enterprise environment, where many different applications are used
simultaneously to add or retrieve data from a central data store. MySQL is
designed more for web applications, where data is maintained and accessed
through a smaller set of programs. Many people have set up very successful
MySQL web applications.
It is easier and cheaper to administer mysql, and it is faster, but less
external software is designed for it. For example, if you might use an
external business intelligence tool, it will work with Oracle, but it might
not work with MySQL, even through ODBC.
In my mind, the two main problems with MySQL are:
1) lack of derived tables
2) lack of subqueries
I'm in the process of switching from Oracle to MySQL. The main reasons for
doing this were:
1) price.
2) administration. I can do DBA stuff on Oracle, but it's much easier and
faster to do it on MySQL. Things that take a long time and significant study
on oracle don't even require you to think about them on mysql.
3) hardware. Given hardware can handle much more data much faster on MySQL.
4) support. Oracle has a vested interest in keeping discussion of its
product hidden inside proprietary tech support databases. Thus problems in
the product are not obvious until you hit them. I didn't want to buy oracle
support (they told us it started at $10k).
5) focus. Where is Oracle heading? Towards selling services and other
applications to enterprise customers. They don't want small customers, and
they don't want to make the product easier to use. They sell the product to
conservative managers who are willing to spend extra money to ensure they
have something that will do what they want, and Oracle will do most things
if you spend enough money on consultants and hardware.
hope this helps.
braxton
-----Original Message-----
From: johnd [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 5:02 PM
To: [EMAIL PROTECTED]
Subject: Run time version of MySQL (Detail)
Hi,
We will delevope web based applications to put the databases on MySQL
instead of Oracle.
We will have plateforms such as:
1). IBM desktop 400 mhz processor 256 MB RAM 6 GB plus 20 GB hard drives
Win2000 Server installed; or
2). Digital UNIX 500 mhz Alpha processor 1 GB RAM 35 GB RAID 5 with UNIX
4.0f installed
The cost is so good for MySQL. What about the performace during working load
web application databases?
Could you tell us about your opinions or any of your information?
Thanks for your information.
Regards,
John Ding
---------------------------------------------------------------------
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
