-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Scott Hodson wrote: | Seems like most of the focus here is on the MM driver, but has anybody | used the Resin JDBC driver for MySQL? We ran some tests of a benchmark | we created based on some typical queries in our system and the Resin | driver was 20-40% faster than the MM driver, across the board. | | http://www.caucho.com/projects/jdbc-mysql/index.xtp | | | --------------------------------------------------------------------- | Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before | posting. To request this thread, e-mail java...@lists.mysql.com | | To unsubscribe, send a message to the address shown in the | List-Unsubscribe header of this message. If you cannot see it, | e-mail java...@lists.mysql.com instead. |

MM.MySQL has been having some performance tuning done to it lately, and the latest release is within 5-10% performance-wise of resin.

What resin doesn't have is anything other than the simplest operations in JDBC. It's nowhere close to JDBC-compliant. It doesn't do anything that's supported in JDBC-2.0. It doesn't have years of functionality ported into it to support the quirks of various application servers and development tools. All of this functionality to support compliance and other tools unfortunately slows things down a bit. However, the combination of MM.MySQL and MySQL is faster and more stable than everything but Oracle-9i (which it keeps pace with quite fine) in benchmarks done by independent sources.

There is a version of MM.MySQL to be released soon that passes all of the JDBC compatibility test suite except for stored procs (which MySQL doesn't have, _yet_).

And finally, there's one thing that Resin doesn't have, which is that MM.MySQL is now a product available from MySQL-AB, with full support and licensing options available. Watch for the official announcement in July :)

-Mark -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6-2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAj0cY/wACgkQlyjUJM+7nP4KKwCfTK7StJmv87G8U2lCD+lcB9H9 ffIAn1bar5eWntg7WePYllwQJz4khVi/ =4vDQ -----END PGP SIGNATURE-----