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? Thanks, Jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4