• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

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 ?
0
kennethlowe
Asked:
kennethlowe
  • 3
1 Solution
 
CFXPERTCommented:
This question has sort of been answered in a similiar question.

SEE the following

http://www.experts-exchange.com/coldfusion/Q_20319111.html
0
 
CFXPERTCommented:
The best datasource?  There is no such thing.  A datasource is a datasource.  I have offered the best suggestions you'll find and if you need any other assistance you can email me at kerry@tefftnet.com.

cheers

:)
KWK
0
 
kennethloweAuthor Commented:
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
0
 
CFXPERTCommented:
Not a problem.

Have a good day.

:)

KWK
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now