Reputation
414
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 4 13
Newest
 Commentator
Impact
~20k people reached

  • 0 posts edited
  • 0 helpful flags
  • 33 votes cast
Aug
5
comment Where to store average value in db?
That would makes sense if I have a small list of values to cache, but initiating a cache of 10k vaues is overkill, isn't it? Especially if I know over 70% of that wont be used at all.
Aug
5
awarded  Commentator
Aug
5
comment Where to store average value in db?
As mentioned in my (updated) question, I am calculating average via mysql events. So the transaction overheads you are talking about dont exist.
Aug
5
comment Where to store average value in db?
Well, I will be calling update from db, via trigger or event. And yes, as you said updating it for every update is really bad idea. So I am doing as I explained in my question.
Aug
5
comment Where to store average value in db?
Its not just about speed, but also simplicity. If I have to list highest and lowest rated restaurants, wouldn't it be a simple query to write if I already have computed the average already?
Aug
5
revised Where to store average value in db?
Added more context
Aug
5
awarded  Yearling
Aug
5
asked Where to store average value in db?
May
29
awarded  Popular Question
Mar
20
awarded  Curious
Feb
5
comment Why is C# ASP.NET generally not regarded as a rapid web development framework?
Conflicting terminology it is. Wikipedia's definition for Rapid means quick to action as against to long term planning while in plain English, for most people, it would mean decreasing application's incubation time.
Aug
27
awarded  Popular Question
Aug
14
awarded  Famous Question
Mar
26
awarded  Popular Question
Aug
1
awarded  Tumbleweed
Feb
12
revised Can't I just use all static methods?
added 297 characters in body
Dec
20
awarded  Good Question
Dec
19
awarded  Notable Question
Jun
24
comment What's the best way to manage list item sort order with Drag & Drop UI?
I should store the order on server-side. It doesnt matter if the order is stored on every drag-drop or by clicking a button once and for all.
Jun
23
awarded  Yearling