Load large datas issue

6 replies. Last post: November 8, 2010 9:32 PM by Frank Bruce
Tags :
  • New Discussion
  • New Question
  • New Product Feedback
Frank BruceMember

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>
1 attachment
All times are GMT -5. The time now is 12:57 PM.
Previous Next