iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
My table have about 350000 records,I have bind the table to Webgrid.
I use "PagingMode="VirtualLoad" VirtualPageSize="50" VirtualLoadMode="LargeData" ",but when the page Load data every time ,it cost about 8 seconds!
It is so slowly! Any one can help me???
<ISWebGrid:WebGrid ID="WebGrid1" runat="server" Height="300px" UseDefaultStyle="True" Width="300px" DataSourceID="SqlDataSource1"> <LayoutSettings PagingMode="VirtualLoad" VirtualPageSize="50" VirtualLoadMode="LargeData" AllowAddNew="Yes" AllowDelete="Yes" AllowEdit="Yes"> </LayoutSettings> <RootTable DataKeyField="id"> <Columns> <ISWebGrid:WebGridColumn Caption="id" DataMember="id" Name="id" Width="100px" DataType="System.Int64"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="name" DataMember="name" Name="name" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="pwd" DataMember="pwd" Name="pwd" Width="100px"> </ISWebGrid:WebGridColumn> </Columns> </RootTable> </ISWebGrid:WebGrid>
Please check our reference sample, ClassicPagingUsingCustomDataRetrieval.aspx, in the local WebGridSamples project or check the live sample at the following link, http://live.intersoftpt.com/cs/WebGrid/ClassicPagingUsingCustomDataRetrieval.aspx.
In order to perform custom data retrieval for classic paging, we need to set the value of PagingLoadMode property to Custom. To handle the logic that performs custom data retrieval, we need to have a select method with three parameters signature: startRow, maximumRows, and sortExpression. To learn more about custom data retrieval codes, please take a look at App_Code\dsNorthwind_Extended.cs.
We also provide more articles that discuss about this topic, please kindly check WebGrid 7 documentation and search for the title of the following topic:
Please let us know whether it helps or not.
Although WebGrid supports large table binding, we often recommend customers to load and retrieve data efficiently by either using predefined filter or asked user to enter some search criteria before requesting data. Best design & pattern in application architecture is always our first priority and suggestion.
There are articles and sample that you can read which discuss about how to improve WebGrid’s performance. Some of the articles are listed down here.
The sample can be checked at here.
Hope this helps.
Anyway,it can solve my problem.If I do not install .netframework3.5,I will can not use Linq.Could you give me the other suggestion for loading large datas?thank you,Yudi
To load large data into client’s browser may cause performance issue.
In order to get better performance when render large data, we need to split the data into small pieces. Combining paging, grouping, load on demand, and client-binding feature of WebGrid might helps.
Could you please show me a demo about using paging stored procedure with Webgrid ??
Like:
<script type="text/javascript"> Load() { //init PagingSliderBar } getFirstPage() { //call C# code with paging } getNextPage() { //call C# code with paging } getPreviousPage() { //call C# code with paging } getLastPage() { //call C# code with paging } </script>
thank you,Yudi
Thank you,you are so kind to me!It is very helpful!
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname