Hendra Kurniawan wrote:I assume this won't be the case for web app, since the overhead will be too great.
Premature optimization. How do you know that until you try it? I routinely fetch things in real time (using jQuery and Ajax).
is it recommended to hit the DB everytime the dropdown is "dropped" by user?
As with any other question, the answer is "it depends". Is the data static? Then no. Does the data change? If so, how often? Daily? Hourly? Every millisecond?