It depends on how often you use the views and how much of data you need from all the 10 tables. If majority of your usage is only couple of columns from couple of tables then smaller view with only required tables will be more efficient as opposed to one giant view that is called every time even if most of the info the view returns is not required.
Friday, March 9, 2012
Large views vs multiple small views
Which is more efficient? One large view that joins >=10 tables, or a few smaller views that join only the tables needed for individual pages?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment