Brooke,
Couple of points of inquiry.
1) 50k records can be a little OR a lot. How much actual data is returned.
Is a lot of textual? Management studio might look really fast but the
problem could be a lot of character data buffering to the web server.
2) have you looked at the activity
Just for clarification, do you have a unique index with the three non-primary
columns, or are those indexed individually? If individually, I would suggest a
combined index, at least of the usr_id and form_id columns, as those are
numeric values and then a separate index of the date column.
There are a couple of queries that you can run while your query is
executing to see if there is anything else running that is blocking the
execution. The first will show all running activities and identify if any
are blocking one another. The second is just a handy script to see what's
for analyzing the execution plan, check out SQL Sentry Plan Explorer. They
have a free version, and it's a much better tool for execution plan
analysis than Management Studio
On Thu, Dec 5, 2013 at 10:03 AM, Mark A Kruger mkru...@cfwebtools.comwrote:
Brooke,
Couple of points of inquiry.
Could never figure this out, but we had a similar issue on 2005 with a date
time column.
I remember we changed from a cfquery to a stored procedure and it was
resolved.
Byron Mann
Lead Engineer Architect
HostMySite.com
On Dec 5, 2013 12:27 PM, Brook Davies cft...@logiforms.com wrote:
This
, I'll try them!
Whohoo! Cftalk is alive!!
Brook
-Original Message-
From: Byron Mann [mailto:byronos...@gmail.com]
Sent: December-05-13 10:22 AM
To: cf-talk
Subject: Re: Simple SQL Query sometimes really Slow?
Could never figure this out, but we had a similar issue on 2005 with a date
6 matches
Mail list logo
