On Mon, Jan 19, 2009 at 5:37 PM, Adrian Lynch wrote:
Is it true that the SQL will perform better if you cfqp any static values
too? So:
WHERE cfqp value=1
over:
WHERE id = 1
I'm sure you can design scenario's where that will be faster (mainly
where you are approaching the maximum number
Morning Guys and Girls,
I'm running ColdFusion 8 Standard and SQL Server 2005 Workgroup edition. I'm
using The standard SQL Server driver that comes with CF8.
I'm having a strange performance issue with a particular query. When running
the query from SSMS it returns the dataset in less than a
...@thinkbluemedia.co.uk]
Sent: 19 January 2009 10:23
To: cf-talk
Subject: Coldfusion killed my query?
Morning Guys and Girls,
I'm running ColdFusion 8 Standard and SQL Server 2005 Workgroup
edition. I'm using The standard SQL Server driver that comes with CF8.
I'm having a strange performance issue
Morning Adrian, thanks for getting back to me.
This is definitely not caused by the output/dump of the queries, even when all
those are removed it takes the same amount of time to return the page. This is
not a large query to return, simply a single row containing 2 columns. The
query looks as
Try running this query by itself on a cf page, to
see if maybe one of the other querries on the page is somehow blocking it
At 06:03 AM 1/19/2009, you wrote:
Morning Adrian, thanks for getting back to me.
This is definitely not caused by the output/dump
of the queries, even when all those
Another thing to try: put the query in a sproc and call it with
cfstoredproc. Theoretically, modern SQL Server has made it so that cfquery
(ad-hoc) is as fast as cfstoredproc...but...maybe...
Let us know...
On Mon, Jan 19, 2009 at 7:17 AM, Al Musella, DPM
muse...@virtualtrials.comwrote:
Try
Hello Guys,
Thank you all for your ideas. After speaking with [Justice] over on the IRC
channel I removed the cfqueryparam / and found it ran smooth as silk. Seems
that there was some form of datatype mismatch going on, after changing the
cf_sql_type on the queryparam we've got it running at
What the heck?! Never would have guessed that. You changed cf_sql_type on
which queryparam from what to what?
On Mon, Jan 19, 2009 at 7:55 AM, Robert Rawlins
robert.rawl...@thinkbluemedia.co.uk wrote:
Hello Guys,
Thank you all for your ideas. After speaking with [Justice] over on the IRC
Thank you all for your ideas. After speaking with [Justice] over on the IRC
channel I
removed the cfqueryparam / and found it ran smooth as silk. Seems that
there was
some form of datatype mismatch going on, after changing the cf_sql_type on the
queryparam we've got it running at proper
Is it true that the SQL will perform better if you cfqp any static values
too? So:
WHERE cfqp value=1
over:
WHERE id = 1
Adrian
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: 19 January 2009 16:31
To: cf-talk
Subject: Re: Coldfusion killed my query
Is it true that the SQL will perform better if you cfqp any static values
too? So:
WHERE cfqp value=1
over:
WHERE id = 1
I don't think so, generally. But query performance can be all over the
map - there are a lot of contributing factors. So I wouldn't be
entirely surprised if it did
11 matches
Mail list logo