Coldfusion MX ? ? ?
Posted on 2002-07-23
I've been using CFServer 4.5 for a while and is now testing the Coldfusion MX Enterprise server - on a MS SQL Server 7.0 !
However I'm a bit worried about potential performance issues regarding W2000, CF MX and MS SQL 7.0/2000 !
Any comments on that ?
Here is piece of TechNote 23131 from Macromedia.com :
Note: The ODBC SOCKET is a JDBC Type 3 driver which translates JDBC calls into the middle-tier server, which then translates the request to the database-specific native-connectivity interface. Because database-specific code must be executed in the middle-tier, the ODBC SOCKET Type 3 driver does not perform as fast as the Microsoft SQL Server Type 4 driver which converts JDBC calls into the network protocol used directly by the database.
BTW : How can you create the best datasource for MS SQL SERVER ?