Intersoft Community - WebGrid Enterprise - Load large datas issue

Load large datas issue

qq397472251 — Mon, 08 Nov 2010 21:32:55 GMT

Thank you,you are so kind to me!
It is very helpful!

Load large datas issue

yudi — Mon, 08 Nov 2010 21:27:25 GMT

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:

Custom Paging
Walkthrough: Implementing Custom Paging using ObjectDataSource
Walkthrough: Implementing Custom Paging using ISDataSource
How-to: Implement Custom Load-On-Demand Paging

Please let us know whether it helps or not.

Load large datas issue

qq397472251 — Sun, 07 Nov 2010 21:54:22 GMT

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

Load large datas issue

yudi — Sun, 07 Nov 2010 20:59:18 GMT

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.

Load large datas issue

qq397472251 — Fri, 05 Nov 2010 05:29:31 GMT

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

Load large datas issue

yudi — Thu, 04 Nov 2010 02:52:32 GMT

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.

Load large datas issue

qq397472251 — Wed, 03 Nov 2010 04:53:33 GMT

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>