Joseph, Have a look at http://dev.mysql.com/tech-resources/features.html. It lets you compare MySQL to various other popular databases.
Warning: I'd take this information with some caution. I don't mean to suggest that it is false, just that the emphasis seems to be on making MySQL look good and glossing over its limitations at times. For example, when comparing MySQL 4.0.13 with DB2 Version 8.1, they note that DB2 8.1 doesn't have a CURRENT_USER function; I assume that's true (I'm running DB2 7.2 and haven't upgraded yet) but it may lead you to believe that there is no way to determine the identify of the current user in DB2. In fact, the 'user' keyword will do exactly that, e.g. 'select user from sysibm.sysdummy' *will* return the user id of the current user. With regards to glossing over limitations, one example is the 'subqueries' comparison: they admit that MySQL doesn't have them and that DB2 does but the fact that this is a single entry in a rather large table suggests that this is of minimal concern and is no more concern than the 'current_user' vs. 'user' point I mentioned. In fact, the absence of subqueries in MySQL is a big issue for a great many MySQL users since subqueries are such a fundamental part of most SQL. MySQL will be providing subqueries in MySQL 4.1.x but some products, like DB2, have had them from Day 1. Rhino ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 06, 2004 11:09 PM Subject: Features for Evaluation > Hi, I am setting up a lab to evaluate main features of MySQL so that > provide advise for other departments to consider for their choice of > database. Do you have a list of such features? Or do you have similar > evaluation reports for my reference? > Thanks, > Joseph > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
