I'm a little confused about this. And Data-Direct's website muddies the waters further. Is this conclusive that the MS JDBC driver significantly outperforms the one bundled with CFMX Enterprise? And that it isn't an OEM from Data-Direct? Data-Direct implies MS is using their driver.
Jeff -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Kief Sent: Monday, March 17, 2003 2:45 PM To: [EMAIL PROTECTED] Subject: RE: RE: [CFCDev] CFC Performance Problem (OLD-Resolved) Fantastic Joe! I will definitely check this out. Thanks! chris >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >Behalf Of Joe Eugene >Sent: Monday, March 17, 2003 8:34 AM >To: [EMAIL PROTECTED] >Subject: Re: RE: [CFCDev] CFC Performance Problem (OLD-Resolved) > >Chris, > >Download the JDBC Drivers (Any Vendor), in this case MS-SQL Server from >Microsoft. >http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7- >4c4d-8f7b-3d47969e66ae&DisplayLang=en >This only works with SQL-Server 2000, 7 you are out of luck. > >1.Install the driver, copy the three *.jar files in the /lib directory >to /CFusionMX/wwwroot/WEB-INF/lib. 2.In cf-admin, go to JVM/classes >setting, enter the classpath to the directory (wwwroot/WEB-INF/lib), >you will need to re-start cfmx after this. >3.Create an "Other" datasource in Cf-Admin, give it the "Url connection >String" and Driver Name. Different drivers vary for the connection string >params. check docs. > >This is probably the best configuration for optimal performance. > >Joe Eugene > > > > > > > >-------Original Message------- >From: Chris Kief <[EMAIL PROTECTED]> >Sent: 03/17/03 01:51 PM >To: [EMAIL PROTECTED] >Subject: RE: [CFCDev] CFC Performance Problem (OLD-Resolved) > >> >> Joe, > >This is interesting. Could you possibly give a quick rundown on how you >went about switching the drivers used by CFMX...I haven't done this >before. > >Thanks! >chris > > > >>-----Original Message----- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >Behalf >>Of Joe Eugene >>Sent: Monday, March 17, 2003 7:36 AM >>To: [EMAIL PROTECTED] >>Subject: [CFCDev] CFC Performance Problem (OLD-Resolved) >> >>Spend quite alot of time testing CFC's. Finally gave up and switched >>SQL- Server Data-Direct Driver to Microsoft SQL Server JDBC Driver >>SP1. >> >>Data-Direct (CFMX default) >>Execution time 300-900ms (very inconsistent) >> >>Microsoft JDBC Driver SP1 >>Execution time 0-20ms (consistent) >> >>Problem was the Very Poor Data-Direct drivers. >>Lesson.. Always go with DB vendor drivers. >> >>Joe Eugene >>---------------------------------------------------------- >>You are subscribed to cfcdev. To unsubscribe, send an email to >>[EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message >>of the email. >> >>CFCDev is run by CFCZone (www.cfczone.org) and supported >>by Mindtool, Corporation (www.mindtool.com). > > >---------------------------------------------------------- >You are subscribed to cfcdev. To unsubscribe, send an email >to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' >in the message of the email. > >CFCDev is run by CFCZone (www.cfczone.org) and supported >by Mindtool, Corporation (www.mindtool.com). >> >---------------------------------------------------------- >You are subscribed to cfcdev. To unsubscribe, send an email >to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' >in the message of the email. > >CFCDev is run by CFCZone (www.cfczone.org) and supported >by Mindtool, Corporation (www.mindtool.com). ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
