kennethlowe
asked on
Coldfusion MX ? ? ?
Hi there,
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.
Regards,
Kenneth
BTW : How can you create the best datasource for MS SQL SERVER ?
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.
Regards,
Kenneth
BTW : How can you create the best datasource for MS SQL SERVER ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Well CFEXPERT...
I might be a bit rusty in my english...it's sometimes hard to express exactly what you want to know ;-)
About the datasource I realy ment somthing about how the different types of CF avaible/usable datasource performed in the kind of environment I described above.
Anyway...I decided not to go with MX at the moment...
Thank You for answering.
/Kenneth
I might be a bit rusty in my english...it's sometimes hard to express exactly what you want to know ;-)
About the datasource I realy ment somthing about how the different types of CF avaible/usable datasource performed in the kind of environment I described above.
Anyway...I decided not to go with MX at the moment...
Thank You for answering.
/Kenneth
Not a problem.
Have a good day.
:)
KWK
Have a good day.
:)
KWK
SEE the following
https://www.experts-exchange.com/questions/20319111/CF-MX-worth-using-or-utter.html