I honestly do not know if I'm asking a very obvious thing, which we look at and say like this: Obviously the dynamic query per request is better!
But come on ...
The application
We are talking about a web application in ASPNET.MVC 4.0, of indicators - style a dashboard. The size of the application I would say would be small / medium with Oracle database.
Scenery
I need to make N querys to display the bookmarks. However, the filters can be made in memory or directly in the bank. The point is, as we are talking about indicators, I have mathematical operations involved. That is, I need a result of type:
ID Valor Tipo
1 25560.00 1
2 2330.00 1
3 140.00 2
4 10.00 1
5 50.00 3
6 40.00 3
7 33.00 1
At the end of the day ... my request would be something like:
Question
Which is better?