I am trying to use view in ids v7.3. but i am having performance issues with it. It seems like its creating the view on the fly. I have mulitple joins to be perfomed and so i created the view.
Has anybody got any suggestion.
A view by itself typically gives no degredation. Look at the output of SQLEXPLAIN to see what the optimizer is attempting to do. You could compare that to the sql/joins without the view. They should be the same.