A new version of the MySQL driver has been
released that detects ColdFusion when it is running with Coldfusion MX
7 (and 8). This should result in much better performance for CF/MySQL
Setting "useDynamicCharsetInfo" to "false" now causes
driver to use static lookups for collations as well (makes
ResultSetMetadata.isCaseSensitive() much more efficient, which leads to
performance increase for ColdFusion, which calls this method for every
column on every table it sees, it appears).
The driver automatially detects when it is running in a ColdFusion
MX server (tested with version 7), and uses the configuration bundle
coldFusion, which sets "useDynamicCharsetInfo" to "false" (see previous
entry), and sets useLocalSessionState and autoReconnect to true.
update for this driver should should help with performance. I have
personally not tested this driver but wanted to pass this information
Thanks for the tip! After testing this week we noticed a significant improvement (around 20%) over what till now has been the fastest driver when running cfmx7 with mysql 5 (which is NOT the jdbc driver but the old mysql driver with the oldpassword hack). We've gone ahead and put it live on our site travellerspoint.com, so thanks again!
All in all, it's also just great to finally have a new driver :)
With some of the null pointer errors on CF 8.01 I have been looking for the driver that you are mentioning and aren't able to find it. Can you point us to the URL from Adobe on this new/updated driver?