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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4