Design question.
Which is a better design?
We need to present data to a user. So to do this we decided to create a view(database) which is join of two tables so that we can avoid some heavy duty computution in the presentation layer. There is one more information which we need to present in this layer. This information is contained in another table and it needs a loop to determine the information.(Some thing like a status of a field - whether it is approved or denied. If its approved then all the rows of that entry should be true. If its denied then any of one of the row should be false).
Now the question is - Is it a good thing to embedd this iteration processing in the view itself or is it better to do in the DAO object(java code)
I am looking at the performance factor to base my decision.
Any respones would be appreciated.
