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

Popular posts from this blog

routing - AngularJS State management ->load multiple states in one page -

python - GRASS parser() error -

json - Gson().fromJson(jsonResult, Myobject.class) return values in 0's -