Click here to Skip to main content
13,293,894 members (60,972 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.
 
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? 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 

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 |
Web04 | 2.8.171207.1 | Last Updated 14 Dec 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid