> I think the MS driver is licensed from DataDirect, and is essentially the > same as what you get with CFMX. Dave,
I dont think you are right. You might want to check this. http://www.datadirect-technologies.com/products/jdbc/docs/ddsqlvsMS-Final.as p MS-SQL Server JDBC does NOT support SQL-Server 7.0, while Data-Direct Drivers does, that perhaps is why CFMX includes Data-Direct. I havent done any testing but its likely MS JDBC Drivers will perform much better than Data-Direct. I am not sure if you have noticed, calling multiple queries in a sequence in CFMX appears to be slow using SQL-Server and CFMX-JDBC(Data-Direct) Connection. Can you help to do some performance testing? CASE 1. CFC(request scope)Data Layer has multiple queries and has validation/argument parameters. 2. Call queries in CFC (Maybe 3-5 queries, inserts and selects etc) 3. Switch JDBC Drivers (MS-SQL Drivers and CFMX Data-Direct) to get timing. Thanks Joe Eugene > -----Original Message----- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Friday, March 14, 2003 4:02 PM > To: CF-Server > Subject: RE: database access question > > > > MS-SQL Server JDBC Type IV Driver(SP1), think this actually > > performs better than Data-Direct. > > I think the MS driver is licensed from DataDirect, and is essentially the > same as what you get with CFMX. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ______________________________________________________________________ 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 ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
