Urgent Advice needed - What do I need to set for fastest page and data grid load??
-
Hiya I have a web form that contains a number of data grids. The grids display about 600 hundred database records each. The grids contain Select,Update and Delete buttons. The data is retrieved using DataSets and DataTables. My problem is that the grids load the records VERY VERY SLOWLY!! Sometimes over 1 minute!! What properties can I set on the web form and the data grids to make them display the fastest speed possible??? Thanks
-
Hiya I have a web form that contains a number of data grids. The grids display about 600 hundred database records each. The grids contain Select,Update and Delete buttons. The data is retrieved using DataSets and DataTables. My problem is that the grids load the records VERY VERY SLOWLY!! Sometimes over 1 minute!! What properties can I set on the web form and the data grids to make them display the fastest speed possible??? Thanks
There could be a number of things.. The first could be the obvious, 600 records each on "a number" of data grids on one form.. This could be churning out a lot of data. Also, it may be copying all that in ViewState which takes even more bandwidth. In addition, forms in the browser are slow already. Do you have more details? Rocky <>< www.HintsAndTips.com www.MyQuickPoll.com www.GotTheAnswerToSpam.com
-
Hiya I have a web form that contains a number of data grids. The grids display about 600 hundred database records each. The grids contain Select,Update and Delete buttons. The data is retrieved using DataSets and DataTables. My problem is that the grids load the records VERY VERY SLOWLY!! Sometimes over 1 minute!! What properties can I set on the web form and the data grids to make them display the fastest speed possible??? Thanks
Write an sp to return multiple recordsets-> this avoids multiple roundtrips asp.net page to database(if you have followed this way). Try to filter the records returned as much as possible or limit the no of records to be displayed.
-
Hiya I have a web form that contains a number of data grids. The grids display about 600 hundred database records each. The grids contain Select,Update and Delete buttons. The data is retrieved using DataSets and DataTables. My problem is that the grids load the records VERY VERY SLOWLY!! Sometimes over 1 minute!! What properties can I set on the web form and the data grids to make them display the fastest speed possible??? Thanks
Use multiple pages and display only, let's say, 10 records at one time.... Regards, Alexandru Savescu