Click here to Skip to main content
12,633,414 members (32,265 online)

Welcome to the Lounge

   

For discussing anything related to a software developer's life. Technical discussions are encouraged, but click here to ask your programming questions.

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.
 
GeneralWell, I Give Up (on SQL) Pin
AspDotNetDev14-Jan-13 16:09
protectorAspDotNetDev14-Jan-13 16:09 
GeneralRe: Well, I Give Up (on SQL) Pin
Marc Clifton14-Jan-13 16:33
protectorMarc Clifton14-Jan-13 16:33 
GeneralRe: Well, I Give Up (on SQL) Pin
Chris Maunder14-Jan-13 16:35
adminChris Maunder14-Jan-13 16:35 
GeneralRe: Well, I Give Up (on SQL) Pin
AspDotNetDev14-Jan-13 17:14
protectorAspDotNetDev14-Jan-13 17:14 
GeneralRe: Well, I Give Up (on SQL) Pin
PIEBALDconsult14-Jan-13 17:54
memberPIEBALDconsult14-Jan-13 17:54 
GeneralRe: Well, I Give Up (on SQL) Pin
AspDotNetDev14-Jan-13 18:23
protectorAspDotNetDev14-Jan-13 18:23 
GeneralRe: Well, I Give Up (on SQL) Pin
Chris Maunder14-Jan-13 19:14
adminChris Maunder14-Jan-13 19:14 
GeneralRe: Well, I Give Up (on SQL) Pin
AspDotNetDev14-Jan-13 19:55
protectorAspDotNetDev14-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) Pin
Nagy Vilmos15-Jan-13 1:10
memberNagy Vilmos15-Jan-13 1:10 
GeneralRe: Well, I Give Up (on SQL) Pin
PIEBALDconsult14-Jan-13 16:52
memberPIEBALDconsult14-Jan-13 16:52 
GeneralRe: Well, I Give Up (on SQL) Pin
Rutvik Dave14-Jan-13 19:32
memberRutvik Dave14-Jan-13 19:32 
GeneralRe: Well, I Give Up (on SQL) Pin
Jim Meadors14-Jan-13 21:05
memberJim Meadors14-Jan-13 21:05 
GeneralRe: Well, I Give Up (on SQL) Pin
digimanus14-Jan-13 22:58
memberdigimanus14-Jan-13 22:58 
GeneralRe: Well, I Give Up (on SQL) Pin
AspDotNetDev15-Jan-13 4:40
protectorAspDotNetDev15-Jan-13 4:40 
GeneralRe: Well, I Give Up (on SQL) Pin
digimanus15-Jan-13 4:43
memberdigimanus15-Jan-13 4:43 
GeneralDell Buyout Pin
Kevin Marois14-Jan-13 12:16
memberKevin Marois14-Jan-13 12:16 
GeneralRe: Dell Buyout Pin
DaveAuld14-Jan-13 12:29
mentorDaveAuld14-Jan-13 12:29 
GeneralRe: Dell Buyout Pin
_Maxxx_14-Jan-13 13:26
member_Maxxx_14-Jan-13 13:26 
GeneralRe: Dell Buyout Pin
DaveAuld14-Jan-13 13:31
mentorDaveAuld14-Jan-13 13:31 
GeneralRe: Dell Buyout Pin
_Maxxx_14-Jan-13 13:47
member_Maxxx_14-Jan-13 13:47 
NewsHMV Next? Pin
DaveAuld14-Jan-13 10:59
mentorDaveAuld14-Jan-13 10:59 
GeneralRe: HMV Next? Pin
Clifford Nelson14-Jan-13 11:04
memberClifford Nelson14-Jan-13 11:04 
GeneralRe: HMV Next? Pin
DaveAuld14-Jan-13 11:08
mentorDaveAuld14-Jan-13 11:08 
GeneralRe: HMV Next? Pin
Clifford Nelson15-Jan-13 8:12
memberClifford Nelson15-Jan-13 8:12 
GeneralRe: HMV Next? Pin
Mark_Wallace14-Jan-13 21:24
memberMark_Wallace14-Jan-13 21:24 

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.161208.2 | Last Updated 9 Dec 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid