Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 278
  • 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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

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