CFMX 6.1 delaying query results

Question

I have a query that seems to be hanging up, and all
indications point to a CFMX problem, not a SQL problem. I tested
executing the stored procedure three times (non-concurrently) via
CFQUERY and SQL Query Analyzer using the same command, and the
runtime results are as follows:

CFMX
---

158015ms ~ 158 seconds
116172ms ~ 116 seconds
115203ms ~ 115 seconds

Query Analyzer
---

7 seconds
7 seconds
7 seconds

Any suggestions on how I can determine what the exact problem
is?

SpiderFromMars · Answer

Instead of using the CFQUERY tag to run a stored procedure,is there some reason you are not using CFSTOREDPROC?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded