This may not be the right place to post this (man, CF-TALK has changed a lot
in the last 5 or so years ;)).
I have a simple SQL query that is showing up as running slow. When I run it
via the Management Studio it is sometimes fast 0.1 seconds and sometimes,
seemingly randomly slow 1.5
-
From: Brook Davies [mailto:cft...@logiforms.com]
Sent: Thursday, December 05, 2013 11:26 AM
To: cf-talk
Subject: Simple SQL Query sometimes really Slow?
This may not be the right place to post this (man, CF-TALK has changed a lot
in the last 5 or so years ;)).
I have a simple SQL query
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.
-to-force-ind
ex-query-hints-index-hint-part2/
Hope this helps,
-- Jeff
Original Message
From: Brook Davies cft...@logiforms.com
Sent: Thursday, December 05, 2013 10:27 AM
To: cf-talk cf-talk@houseoffusion.com
Subject: Simple SQL Query sometimes really Slow?
This may
[mailto:cft...@logiforms.com]
Sent: Thursday, December 05, 2013 11:26 AM
To: cf-talk
Subject: Simple SQL Query sometimes really Slow?
This may not be the right place to post this (man, CF-TALK has changed a
lot
in the last 5 or so years ;)).
I have a simple SQL query that is showing up
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
7 matches
Mail list logo