sql - What is the most performance efficient method for retrieving 150 fields of data in a asp.net page? -
i have asp.net page, loads in 150 fields of data 8 tables. uses 1 sql view pull in 100 fields 1 table, , sp's bring in rest 7 other tables.
the page displays fields using individual textbox's runat=server, instead of using gridview.
i not proficient on asp.net methods of handling large pages , data, efficiently so.. server cpu efficient method of pulling data in?
should bundle 1 huge sql view , use gridview/repeater?
the html asp.net page 4000 lines long. it's starting hit server cpu hard, 25% on each new page view/load.
Comments
Post a Comment