We haven't had any problems with 4.0.13 yet, but then we din't have any with 3.23.57 either, on windows system the upgrade doesn't upgrade your tables to support transactions but that's no major issue, you can always do each table manually in a few seconds if you so require.
-----Original Message----- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: 09 July 2003 06:59 To: CF-Talk Subject: Re: CF5 to MySQL without ODBC Versoin 3.23.49-nt. Any recommendations for or against moving to MySQL 4.0? ----- Original Message ----- From: "Matt Robertson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 08, 2003 11:37 PM Subject: RE: CF5 to MySQL without ODBC > It shouldn't be slower than Access in any circumstance. It should be > at > *least* twice the speed of Access under light load, and in many cases > even faster than that. > > One thing that comes to mind is that myODBC 3.51 was optimized to work > with mySQL4. You are *probably* using mySQL 3.23. I suggest using > the older mySQL ODBC drivers (2.50) which were current for the older > db. > > -------------------------------------------- > Matt Robertson [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com > -------------------------------------------- > > -----Original Message----- > From: Jim McAtee [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 08, 2003 10:25 PM > To: CF-Talk > Subject: CF5 to MySQL without ODBC > > > We've begun moving a number of application databases from Access97 and > Access2000 to MySQL 3 and we're currently using the MyODBC 3.51 driver > to work with them from CF5. While I'm guessing that MySQL will behave > much better than > Access under load, under light loads it's pretty easy to see that MySQL > via > ODBC is a bit slower than Access. Are there other options beside ODBC > for > using MySQL (running on another machine) with CF5? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4