a very small amount of time to worry about...
Is your DB connection from Cold Fusion using OLE DB, ODBC, JDBC etc, is CF
on the same server as SQL Server, is Query Analyzer taking into account
network response time or is SQL returning the time of execution directly?
I'm certainly not sure...
If you are running over a network, 16ms is trivial and could be caused by
all manner of things including TCP/IP errors/retries, general network load,
and a whole heap of other factors. I really don't think you are every going
to reduce these sorts of times down when you look at the system as a whole.
Comparing Query Analyzer directly against Cold Fusion is fatal. You would be
better off writing an ASP or PHP version of the code and comparing the
results you would get from them as the way in which they work is analogous
to the way CF works...
Paul
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
