Click here to Skip to main content
12,405,895 members (39,654 online)

Welcome to the Lounge

   

For lazing about and discussing anything in a software developer's life that takes your fancy except programming questions.

Technical discussions are encouraged, but click here to ask your programming question.

The Lounge is rated PG. If you're about to post something you wouldn't want your kid sister to read then don't post it. No flame wars, no abusive conduct, no programming questions and please don't post ads.
 
GeneralRe: Follow up on If you had 5 years to live Pin
SoMad10-Jan-14 8:44
professionalSoMad10-Jan-14 8:44 
GeneralRe: Follow up on If you had 5 years to live Pin
Mike Hankey10-Jan-14 9:08
memberMike Hankey10-Jan-14 9:08 
GeneralRe: Follow up on If you had 5 years to live Pin
SoMad10-Jan-14 9:12
professionalSoMad10-Jan-14 9:12 
JokeRe: Follow up on If you had 5 years to live Pin
RyanDev10-Jan-14 8:56
mvpRyanDev10-Jan-14 8:56 
GeneralRe: Follow up on If you had 5 years to live Pin
Mike Hankey10-Jan-14 9:09
memberMike Hankey10-Jan-14 9:09 
GeneralHow to deal with that Kurmudgen Pin
MacSpudster10-Jan-14 11:37
memberMacSpudster10-Jan-14 11:37 
GeneralRe: How to deal with that Kurmudgen Pin
Mike Hankey10-Jan-14 13:23
memberMike Hankey10-Jan-14 13:23 
GeneralMind...Blown Pin
IndifferentDisdain10-Jan-14 8:12
memberIndifferentDisdain10-Jan-14 8:12 
For the life of me, I can't explain this. This isn't intended to be a programming question, more a "nope, don't believe it, even if I'm seeing it" thing.

We host our main app's data in SQL Azure, and we have information in a given table w/ part of the primary key as a datetime (has month-end mutual fund data). One particular function seemed to be taking too long, so we started investigating this afternoon.

If I run a given statement w/ asofdate = '11/30/2013, query takes 20 seconds. Seems slow.

If I run the same statement, changing only asofdate = '10/31/2013', query takes 0.1 seconds. Odd. No significant # of diff recs between those two dates (26,488 for Nov vs. 26,382 for Oct).

So now I'm thinking it's either the way those 11/30 recs were physically stored, or something special about that particular date, until...

If I run the same statement w/ asofdate >= '11/30/2013' (most recent date in db right now), it again takes 0.1 seconds.

Cannot replicate anything close to this in our on-site SQL Server dev dbs.

How the elephant can asofdate >= '11/30/2013' ever be faster than = '11/30/2013'?

modified 10-Jan-14 16:07pm.

GeneralRe: Mind...Blown Pin
GuyThiebaut10-Jan-14 8:25
memberGuyThiebaut10-Jan-14 8:25 
GeneralRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 8:27
memberIndifferentDisdain10-Jan-14 8:27 
GeneralRe: Mind...Blown Pin
GuyThiebaut10-Jan-14 8:38
memberGuyThiebaut10-Jan-14 8:38 
GeneralRe: Mind...Blown Pin
Pualee10-Jan-14 8:35
memberPualee10-Jan-14 8:35 
GeneralRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 8:52
memberIndifferentDisdain10-Jan-14 8:52 
GeneralRe: Mind...Blown Pin
GuyThiebaut10-Jan-14 23:17
memberGuyThiebaut10-Jan-14 23:17 
JokeRe: Mind...Blown Pin
Richard Deeming10-Jan-14 8:35
professionalRichard Deeming10-Jan-14 8:35 
GeneralRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 8:53
memberIndifferentDisdain10-Jan-14 8:53 
GeneralRe: Mind...Blown Pin
Ravi Bhavnani10-Jan-14 10:06
professionalRavi Bhavnani10-Jan-14 10:06 
GeneralRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 10:08
memberIndifferentDisdain10-Jan-14 10:08 
GeneralRe: Mind...Blown Pin
Ravi Bhavnani10-Jan-14 10:16
professionalRavi Bhavnani10-Jan-14 10:16 
AnswerRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 10:21
memberIndifferentDisdain10-Jan-14 10:21 
GeneralRe: Mind...Blown Pin
Ravi Bhavnani10-Jan-14 10:23
professionalRavi Bhavnani10-Jan-14 10:23 
GeneralRe: Mind...Blown Pin
_Maxxx_10-Jan-14 14:46
professional_Maxxx_10-Jan-14 14:46 
GeneralRe: Mind...Blown Pin
_Damian S_12-Jan-14 12:10
professional_Damian S_12-Jan-14 12:10 
GeneralWhile listening to The Who Pin
Ferd Really10-Jan-14 6:48
memberFerd Really10-Jan-14 6:48 
GeneralRe: While listening to The Who Pin
DaveAuld10-Jan-14 7:19
protectorDaveAuld10-Jan-14 7:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 30 Jul 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid