Solved

Coldfusion MX ? ? ?

Posted on 2002-07-23
4
251 Views
Last Modified: 2013-12-24
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
Comment
Question by:kennethlowe
  • 3
4 Comments
 
LVL 5

Expert Comment

by:CFXPERT
Comment Utility
This question has sort of been answered in a similiar question.

SEE the following

http://www.experts-exchange.com/coldfusion/Q_20319111.html
0
 
LVL 5

Accepted Solution

by:
CFXPERT earned 200 total points
Comment Utility
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
 

Author Comment

by:kennethlowe
Comment Utility
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
 
LVL 5

Expert Comment

by:CFXPERT
Comment Utility
Not a problem.

Have a good day.

:)

KWK
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php :…
The purpose of this video is to demonstrate how to automatically show related posts at the bottom of a blog post in WordPress. This will be demonstrated using a Windows 8 PC. Plugin “Yet Another Related Posts Plugin” will be used. Go to your…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now