can some one give me an answer about how views can affect the performance of the application. which is better ? to use stored procedures or to use Views