Thanks for the reply, and thanks for the documentation link. I've got some new news, so I'll add some inline comments to my own post, for posterity. > What I get is: > DriverVersion 2.0.11 > Name Mark Matthews' MySQL Driver > > If this is true, it stuns me in several ways:
It is true. My function is reliable, the datasource was using the stock CFMX 6.1 JDBC driver. > 1. I thought that version 3.1.8 was installed. I was wrong about this datasource, it was using the stock driver. > 2. I suspect that the reported driver is the CFMX 6.1 "native" MySQL > driver. :-O I still think this is the case > 3. The datasource WORKS with our 5.x databases, which I *think* isn't > supposed to be true of the native drivers (due to authentication > protocols, among potential others). We must have run the OLD_PASSWORD routine on our MySQL 5 machines to make it backward compatible with old clients. By the way, this was fortuitous, because I found that 2.0.11 beats the snot out of 3.1.10 for my application. The "new" driver takes 50ms PER VARCHAR FIELD to retrieve one row of data, whereas the old one performs as I would expect, and executes my queries TEN TIMES faster. Thanks, Jamie ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237759 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
