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
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?
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.
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.
Jan
11
comment What are the pros (and cons) of using “Sign in with Twitter/Facebook” for a new website?
I feel point 3 is gibberish. If someone grows well, he is likely creating ways for others to make money too.
Aug
4
comment Whats the best book to master OO language, say C#?
I will be definitely flipping thru C# in depth, but it gets priority 2. Only after Clean Code.
Aug
4
comment Whats the best book to master OO language, say C#?
@Randolf. That would be good one to learn C# specific things but how about the OO itself?