Well I have seen no proof myself that cfquery is faster than
cfstoredprocedure.... What are you classing as highly optimised? For
example its gonna be difficult to say that a SELECT list is highly optimised
as the Query Plan engine decides what's gonna be the best plan (best guess)
you can increase speed but to the degree I would say entitles them to be
'highly optijmised'. A fast query is usually down to the RDBMS schema and
how good it is.
Are you using EXEC to run the Prodedures? Are your Stored Procedures named
in the following (incorrect way) : sp_XXXXX
N
________________________________________
From: Micha Schopman [mailto:[EMAIL PROTECTED]
Sent: 14 July 2004 11:52
To: CF-Talk
Subject: RE: Tuning DB connections?
They are run with cfquery, cfstoredprocedure is much slower than the
plain old cfquery. The queries executed are highly optimized and
extremely fast but it is like the pipe between CF Server, and MSSQL 2000
isn't always optimal. The queries are not cached, and the execution plan
for the query is not important in this scenario :-)
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
________________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
