Click here to Skip to main content

Welcome to the Lounge

   

For lazing about and discussing anything in a software developer's life that takes your fancy.
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 and please don't post ads.

Technical discussions are welcome, but if you need specific help please ask your question here.


 
GeneralRe: Customers Pinprofessional_Damian S_12-Jan-14 13:08 
GeneralRe: Customers Pinmembercharlieg13-Jan-14 4:04 
GeneralFollow up on If you had 5 years to live PinmemberMike Hankey10-Jan-14 9:26 
GeneralRe: Follow up on If you had 5 years to live PinprofessionalRichard Deeming10-Jan-14 9:37 
GeneralRe: Follow up on If you had 5 years to live PinmemberMike Hankey10-Jan-14 9:42 
GeneralRe: Follow up on If you had 5 years to live PinprofessionalSoMad10-Jan-14 9:46 
GeneralRe: Follow up on If you had 5 years to live PinprofessionalSoMad10-Jan-14 9:44 
GeneralRe: Follow up on If you had 5 years to live PinmemberMike Hankey10-Jan-14 10:08 
GeneralRe: Follow up on If you had 5 years to live PinprofessionalSoMad10-Jan-14 10:12 
JokeRe: Follow up on If you had 5 years to live PinmvpRyanDev10-Jan-14 9:56 
GeneralRe: Follow up on If you had 5 years to live PinmemberMike Hankey10-Jan-14 10:09 
GeneralHow to deal with that Kurmudgen [modified] PinmemberMacSpudster10-Jan-14 12:37 
GeneralRe: How to deal with that Kurmudgen PinmemberMike Hankey10-Jan-14 14:23 
GeneralMind...Blown [modified] PinmemberIndifferentDisdain10-Jan-14 9: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 PinmemberGuyThiebaut10-Jan-14 9:25 
GeneralRe: Mind...Blown PinmemberIndifferentDisdain10-Jan-14 9:27 
GeneralRe: Mind...Blown PinmemberGuyThiebaut10-Jan-14 9:38 
GeneralRe: Mind...Blown PinmemberPualee10-Jan-14 9:35 
GeneralRe: Mind...Blown PinmemberIndifferentDisdain10-Jan-14 9:52 
GeneralRe: Mind...Blown PinmemberGuyThiebaut11-Jan-14 0:17 
JokeRe: Mind...Blown PinprofessionalRichard Deeming10-Jan-14 9:35 
GeneralRe: Mind...Blown PinmemberIndifferentDisdain10-Jan-14 9:53 
GeneralRe: Mind...Blown PinprofessionalRavi Bhavnani10-Jan-14 11:06 
GeneralRe: Mind...Blown PinmemberIndifferentDisdain10-Jan-14 11:08 
GeneralRe: Mind...Blown PinprofessionalRavi Bhavnani10-Jan-14 11:16 
AnswerRe: Mind...Blown PinmemberIndifferentDisdain10-Jan-14 11:21 
GeneralRe: Mind...Blown PinprofessionalRavi Bhavnani10-Jan-14 11:23 
GeneralRe: Mind...Blown Pinprofessional_Maxxx_10-Jan-14 15:46 
GeneralRe: Mind...Blown Pinprofessional_Damian S_12-Jan-14 13:10 
GeneralWhile listening to The Who PinmemberFerd Really10-Jan-14 7:48 
GeneralRe: While listening to The Who PinprotectorDaveAuld10-Jan-14 8:19 
General...The Eagles PinmemberMotel Kamzoil10-Jan-14 9:18 
GeneralRe: While listening to The Who PinprotectorOriginalGriff10-Jan-14 9:20 
GeneralPink Floyd PinmemberMike Hankey10-Jan-14 9:23 
GeneralRe: While listening to The Who Pinprofessional_Maxxx_10-Jan-14 15:48 
GeneralLondon Underground map. PinmemberSeptimus Hedgehog10-Jan-14 6:12 
GeneralRule of thumb and config files PinmemberRugbyLeague10-Jan-14 6:09 
GeneralRe: Rule of thumb and config files PinprofessionalManfred R. Bihy10-Jan-14 6:24 
GeneralRe: Rule of thumb and config files PinmemberRugbyLeague10-Jan-14 6:29 
GeneralRe: Rule of thumb and config files PinprofessionalManfred R. Bihy10-Jan-14 6:37 
GeneralRe: Rule of thumb and config files PinmemberRugbyLeague10-Jan-14 6:39 
GeneralRe: Rule of thumb and config files PinmemberSentenryu10-Jan-14 8:33 
GeneralRe: Rule of thumb and config files PinmemberRugbyLeague14-Jan-14 0:56 
GeneralRe: Rule of thumb and config files PinmemberEddy Vluggen10-Jan-14 7:33 
GeneralRe: Rule of thumb and config files PinprofessionalPIEBALDconsult10-Jan-14 9:26 
GeneralRe: Rule of thumb and config files PinprofessionalPIEBALDconsult10-Jan-14 9:25 
GeneralAPOD Pinmembermark merrens10-Jan-14 6:07 
GeneralRe: APOD PinprofessionalManfred R. Bihy10-Jan-14 6:30 
GeneralRe: APOD PinprofessionalglennPattonWork10-Jan-14 7:17 
GeneralRe: APOD PinmemberMike Hankey10-Jan-14 7:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web01 | 2.8.141223.1 | Last Updated 27 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid