Simple SQL Query sometimes really Slow?

2013-12-05 Thread Brook Davies
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

RE: Simple SQL Query sometimes really Slow?

2013-12-05 Thread Mark A Kruger
- 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

Re: Simple SQL Query sometimes really Slow?

2013-12-05 Thread Jon Clausen
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.

re: Simple SQL Query sometimes really Slow?

2013-12-05 Thread Jeff Garza
-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

Re: Simple SQL Query sometimes really Slow?

2013-12-05 Thread richpaul7 .
[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

Re: Simple SQL Query sometimes really Slow?

2013-12-05 Thread Byron Mann
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

RE: Simple SQL Query sometimes really Slow?

2013-12-05 Thread Brook Davies
, 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