Click here to Skip to main content
11,495,319 members (58,837 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: Swatting a fly with a nuke Pin
BobJanova14-Jan-13 23:39
memberBobJanova14-Jan-13 23:39 
GeneralRe: Swatting a fly with a nuke Pin
Johann van der Smut15-Jan-13 0:51
memberJohann van der Smut15-Jan-13 0:51 
GeneralRe: Swatting a fly with a nuke Pin
Bassam Abdul-Baki15-Jan-13 2:36
memberBassam Abdul-Baki15-Jan-13 2:36 
GeneralRe: Swatting a fly with a nuke Pin
Kyudos15-Jan-13 11:04
memberKyudos15-Jan-13 11:04 
GeneralRe: Swatting a fly with a nuke Pin
Bassam Abdul-Baki15-Jan-13 15:56
memberBassam Abdul-Baki15-Jan-13 15:56 
GeneralRe: Swatting a fly with a nuke Pin
Kyudos15-Jan-13 17:13
memberKyudos15-Jan-13 17:13 
GeneralRe: Swatting a fly with a nuke Pin
Bassam Abdul-Baki16-Jan-13 1:37
memberBassam Abdul-Baki16-Jan-13 1:37 
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 
Doing what you are doing was certainly one of my suggestions. The other was looking for patterns in searches and precalculating and caching common searches. You'd essentially lookup the search string in a "precache" table first, then move on to a full search if no luck. That doesn't solve the fundamental problem though.

For raw speed is it practical to simply load everything in a memory cache? It may not be faster than a database, but it may - you could be surprised. RAM is stupid cheap, so should never be an issue (compared to the cost of your time).

Another option is massively denormalising the data, splitting it and storing it among multiple servers, with a single central server (give or take redundancy) farming out requests to the various servers.

A third option is a little old school, but still seems popular: wait half a second so it looks like you're doing something, then return a random set of records. I've seen this very algorithm implemented just a couple of weeks ago.
cheers,
Chris Maunder

The Code Project | Co-founder
Microsoft C++ MVP

GeneralRe: Well, I Give Up (on SQL) Pin
AspDotNetDev14-Jan-13 19:55
protectorAspDotNetDev14-Jan-13 19:55 
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? [modified] 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 
GeneralRe: HMV Next? Pin
DaveAuld14-Jan-13 21:50
mentorDaveAuld14-Jan-13 21:50 
GeneralRe: HMV Next? Pin
GuyThiebaut14-Jan-13 22:49
memberGuyThiebaut14-Jan-13 22:49 
GeneralRe: HMV Next? Pin
PHS24115-Jan-13 2:40
memberPHS24115-Jan-13 2:40 
GeneralRe: HMV Next? Pin
PIEBALDconsult15-Jan-13 14:53
memberPIEBALDconsult15-Jan-13 14:53 
GeneralTo the Rescue Pin
Andy_L_J14-Jan-13 10:10
memberAndy_L_J14-Jan-13 10:10 
GeneralRe: To the Rescue Pin
OriginalGriff14-Jan-13 10:12
mvpOriginalGriff14-Jan-13 10:12 
GeneralRe: To the Rescue Pin
Andy_L_J14-Jan-13 10:51
memberAndy_L_J14-Jan-13 10:51 
GeneralRe: To the Rescue Pin
OriginalGriff14-Jan-13 11:16
mvpOriginalGriff14-Jan-13 11:16 
GeneralRe: To the Rescue Pin
Andy_L_J14-Jan-13 11:28
memberAndy_L_J14-Jan-13 11:28 
GeneralScrew You, SSMS Pin
AspDotNetDev14-Jan-13 10:00
protectorAspDotNetDev14-Jan-13 10:00 
GeneralRe: Screw You, SSMS Pin
Ennis Ray Lynch, Jr.14-Jan-13 10:18
memberEnnis Ray Lynch, Jr.14-Jan-13 10:18 
GeneralRe: Screw You, SSMS Pin
AspDotNetDev14-Jan-13 12:40
protectorAspDotNetDev14-Jan-13 12:40 
GeneralRe: Screw You, SSMS Pin
S Douglas14-Jan-13 11:03
memberS Douglas14-Jan-13 11:03 
GeneralRe: Screw You, SSMS Pin
snorkie14-Jan-13 11:21
membersnorkie14-Jan-13 11:21 
GeneralRe: Screw You, SSMS Pin
mark merrens14-Jan-13 11:05
membermark merrens14-Jan-13 11:05 
GeneralRe: Screw You, SSMS Pin
AspDotNetDev14-Jan-13 12:42
protectorAspDotNetDev14-Jan-13 12:42 
GeneralWindshield Stress Crack Pin
Colin Mullikin14-Jan-13 8:52
memberColin Mullikin14-Jan-13 8:52 
GeneralRe: Windshield Stress Crack Pin
loctrice14-Jan-13 9:08
memberloctrice14-Jan-13 9:08 

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.150520.1 | Last Updated 29 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid