MySQL

Anon

Does MySQL support Joins and what is the major diff between MySQL and Oracle?
My company in thinking about using MySQL instead of Oracle and im in need of there diff info

thanks

Pete

Anon

better subject line!

Anon

MySQL is small, free, easy to use, supports many popular sql statements, including joins.
Oracle is large, expensive, complex to use, but supports just about every sql statement you can think of.

Basically, MySQL is a low-budget, limited functionality database that is
perfect for small to medium size applications.
It is installed in 3 minutes, plugs right into php,perl etc.

But....
If you want to have all sql functions (sub-selects, views etc)
or you are planning on using a huge database with high load, you'll have to move to something more powerfull, like Oracle or Informix.

Anon

My company currently has Oracle 8i and has been an Oracle shop for several years. We are currently moving to a more data driven website where user customizations and presentation data will now be in the database. I've done some simple tests with PHP4 rendering pages both from Oracle(on UNIX) and from MySQL(on Linux). And at least for the tests I've done MySQL is a little faster. Any thoughts on how MySQL will scale when used in this manner?

Anon

The real issue to look at with any database is how may simos you're going to need to handle. Generally, divide the number of users by 10 to 100 to get a simultaneous connection rate number. Persistant connections may or may not divide down, since they often keep their own connection alive for an individual child (i.e. postgresql's module seems to do this, as do several others.)

So, if you're going to handle 150 users at a time, you'll have a simo rate of 2 to 150, depending on architecture design.

Next figure out what percent of the accesses will be reads versus writes. For a heavily written environment, a good locking mechanism like db2, postgresql or oracle is often needed to maintain good performance, but these databases often result in mediocre read results as a trade off.

A system that uses a big database for datastore and pumps out to a mysql database may handle the highest load of all.