Hi, I am using modelpopup window with gridview in it and scrol bar applied( client askes to remove paging feature), when a button is clicked, this modelpopup window is popup for user to select one row of record, then populate the data on selected row to
parent form.
since the data in gridview is big, this causes the modelpopup window a little bit delay to display, does anybod knnow how to improve the formance to make it faster same as when paging feature applied?
Hi , thanks for the information, I read the resource, but it does not say the speed and performance,
Since my SQL table which is displayed on gridview of modelpopup window is not updated frequently, it is a kind of lookup table, I am wondering if I really need to use webservice to achieve it, Are there any easy method to improve the loading speed?
Do you use sql query to display data in modelpopup window with gridview ? If so, you could use index in your sql table, it will help you to improve query performance, reduce storage costs, and reduce maintenance costs.
Do you use sql query to display data in modelpopup window with gridview ? If so, you could use index in your sql table, it will help you to improve query performance, reduce storage costs, and reduce maintenance costs.
Thanks a lot, yes, I am using modelpopup to display gridview data which coming from SQL table,
However, for my case, since I am using storedprocedure, and the table shared with many projects, I may not be able to change the table design in SQL side.
I tried to use SQL Cache Dependency to make it fast, if I only display the plain gridview, it works fast. But after I added Enable Selection in the gridview property, it slows down again, I also tried to bound the buttonitem in the column of gridivew, it
slows down as well.
I do not know why these changes affect the performance, but I have to add the Enable Selection as I need to get the row data and populate them to parent form.
Peter Cong
Member
527 Points
681 Posts
How to improve the loading performance for the gridview with scrolbar in modelpopup window?
Jan 27, 2013 09:37 PM|LINK
Hi, I am using modelpopup window with gridview in it and scrol bar applied( client askes to remove paging feature), when a button is clicked, this modelpopup window is popup for user to select one row of record, then populate the data on selected row to parent form.
since the data in gridview is big, this causes the modelpopup window a little bit delay to display, does anybod knnow how to improve the formance to make it faster same as when paging feature applied?
prasad.magan...
Member
681 Points
215 Posts
Re: How to improve the loading performance for the gridview with scrolbar in modelpopup window?
Jan 28, 2013 05:03 AM|LINK
http://stackoverflow.com/questions/10238215/call-net-method-asynchronously-and-bind-to-grid-upon-completion
http://technico.qnownow.com/how-to-bind-data-to-gridview-using-jquery-ajax/
Prasad Maganti
Peter Cong
Member
527 Points
681 Posts
Re: How to improve the loading performance for the gridview with scrolbar in modelpopup window?
Jan 28, 2013 02:15 PM|LINK
Hi , thanks for the information, I read the resource, but it does not say the speed and performance,
Since my SQL table which is displayed on gridview of modelpopup window is not updated frequently, it is a kind of lookup table, I am wondering if I really need to use webservice to achieve it, Are there any easy method to improve the loading speed?
Chen Yu - MS...
All-Star
21826 Points
2513 Posts
Microsoft
Re: How to improve the loading performance for the gridview with scrolbar in modelpopup window?
Jan 31, 2013 05:31 AM|LINK
Hi,
Do you use sql query to display data in modelpopup window with gridview ? If so, you could use index in your sql table, it will help you to improve query performance, reduce storage costs, and reduce maintenance costs.
http://msdn.microsoft.com/en-us/library/ms188783.aspx
http://www.mssqltips.com/sqlservertip/1206/understanding-sql-server-indexing/
Thanks.
Feedback to us
Develop and promote your apps in Windows Store
Peter Cong
Member
527 Points
681 Posts
Re: How to improve the loading performance for the gridview with scrolbar in modelpopup window?
Jan 31, 2013 02:07 PM|LINK
Thanks a lot, yes, I am using modelpopup to display gridview data which coming from SQL table,
However, for my case, since I am using storedprocedure, and the table shared with many projects, I may not be able to change the table design in SQL side.
I tried to use SQL Cache Dependency to make it fast, if I only display the plain gridview, it works fast. But after I added Enable Selection in the gridview property, it slows down again, I also tried to bound the buttonitem in the column of gridivew, it slows down as well.
I do not know why these changes affect the performance, but I have to add the Enable Selection as I need to get the row data and populate them to parent form.
Any idea?