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 use the programming forums.


 
GeneralWell, I Give Up (on SQL) PinprotectorAspDotNetDev14-Jan-13 16:09 
GeneralRe: Well, I Give Up (on SQL) PinprotectorMarc Clifton14-Jan-13 16:33 
GeneralRe: Well, I Give Up (on SQL) PinadminChris Maunder14-Jan-13 16:35 
GeneralRe: Well, I Give Up (on SQL) PinprotectorAspDotNetDev14-Jan-13 17:14 
GeneralRe: Well, I Give Up (on SQL) PinmemberPIEBALDconsult14-Jan-13 17:54 
GeneralRe: Well, I Give Up (on SQL) PinprotectorAspDotNetDev14-Jan-13 18:23 
GeneralRe: Well, I Give Up (on SQL) PinadminChris Maunder14-Jan-13 19:14 
GeneralRe: Well, I Give Up (on SQL) PinprotectorAspDotNetDev14-Jan-13 19:55 
Chris Maunder wrote:
For raw speed is it practical to simply load everything in a memory cache?

 
That is an option I may explore. Certainly using some dictionaries rather than relying on SQL Server's funky query tuning would be more deterministic.
 
Chris Maunder wrote:
Another option is massively denormalising the data

 
That's the 10+GB option I mentioned not wanting to do in my OP. It'd probably work, but then I'd have a beast of a table to deal with. If we move to Azure, that would have a significant monthly cost associated with it.
 
Chris Maunder wrote:
wait half a second so it looks like you're doing something, then return a random set of records

 
D'Oh! | :doh: I suspect they'll notice when they search for "Ugly Bel" and get "Pretty Belt" instead. Roll eyes | :rolleyes:

GeneralRe: Well, I Give Up (on SQL) PinmemberNagy Vilmos15-Jan-13 1:10 
GeneralRe: Well, I Give Up (on SQL) PinmemberPIEBALDconsult14-Jan-13 16:52 
GeneralRe: Well, I Give Up (on SQL) PinmemberRutvik Dave14-Jan-13 19:32 
GeneralRe: Well, I Give Up (on SQL) PinmemberJim Meadors14-Jan-13 21:05 
GeneralRe: Well, I Give Up (on SQL) Pinmemberdigimanus14-Jan-13 22:58 
GeneralRe: Well, I Give Up (on SQL) PinprotectorAspDotNetDev15-Jan-13 4:40 
GeneralRe: Well, I Give Up (on SQL) Pinmemberdigimanus15-Jan-13 4:43 
GeneralDell Buyout PinmemberKevin Marois14-Jan-13 12:16 
GeneralRe: Dell Buyout PinmentorDaveAuld14-Jan-13 12:29 
GeneralRe: Dell Buyout Pinmember_Maxxx_14-Jan-13 13:26 
GeneralRe: Dell Buyout PinmentorDaveAuld14-Jan-13 13:31 
GeneralRe: Dell Buyout Pinmember_Maxxx_14-Jan-13 13:47 
NewsHMV Next? [modified] PinmentorDaveAuld14-Jan-13 10:59 
GeneralRe: HMV Next? PinmemberClifford Nelson14-Jan-13 11:04 
GeneralRe: HMV Next? PinmentorDaveAuld14-Jan-13 11:08 
GeneralRe: HMV Next? PinmemberClifford Nelson15-Jan-13 8:12 
GeneralRe: HMV Next? PinmemberMark_Wallace14-Jan-13 21:24 

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
Web02 | 2.8.1411023.1 | Last Updated 28 Nov 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid