Can we increase the Report models performance Using Viwes in Report Model Project.
Hi, I have one query in Report model project. See in Report model project we can use either tables or views. Instead of tables I used views in report model. Using views in report models can we increase the performance? But I tried both ways I didn’t find any major difference. Can you give any suggestions using views? Regards, Raju Malla.Raju Malla
February 26th, 2011 6:06am

Hi Raju, Using Views in your data source is generally slower than using tables in your data source since when you open a non clustered view your are effectively creating a temporary table internally which holds the contents of the view. If you are using simple views as your data source instead of tables you may not find much difference in performance. However if you are using views based on several tables and many records you certainly will notice a performance impact. You can create an ETL process to populate tables instead of creating views, but this requires significant development work dependent on you business rules. You can create clustered views where querying a clustered view is similar to querying a table. However clustered views have design limitations. Please see the following links; - http://technet.microsoft.com/en-us/library/cc917715.aspx for SQL Server 2005 and http://msdn.microsoft.com/en-us/library/dd171921(v=sql.100).aspx for SQL Server 2008. I hope this helps, Kind Regards, Kieran. If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/kieranpatrickwood
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 7:03am

Hi Kieran, I a working on a ReportModel project, and finding it a bit slow comparing to same report built directly upon tables. Can you please let me know that how will I increase the performance of the reports developed on the ReportModel. Thanks Nishant
May 20th, 2011 5:33am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics