I'm developing an intranet reporting system -- starting in ASP VBScript -- hitting SQL Server backend.
I will be building summarized tables for many reports. Given that, what are the pros/cons of having the recordset collected from the table directly versus hitting a view based on that table?
Or is it simply a wash?
I will be building summarized tables for many reports. Given that, what are the pros/cons of having the recordset collected from the table directly versus hitting a view based on that table?
Or is it simply a wash?