Large Paging Optimizations

[Mark]

Hi All!

Can you please tell me what you would advise as the best way of displaying a large number of records (IE: a page size of 500 to 1000)? 

Also, are there ways to optimize large quantities (IE: a page size of 10 and over 2000 items)?

Thanks,
Mark

[Princy]

Hi Mark,

You could use the functionality such as Custom Paging or Virtual Scrolling/Paging when you have a large data sets.
For understanding the functionality, go through the following demo on CustomPaging and Grid - Virtualization.

Thanks,
Princy

[Mark]

Thanks!  I've actually tried the Custom Paging in the past.  The Virtual Scroll is new to me.  I have implemented it as per that link (in code behind though).  It "compacts" the data to the left, so that they do not match the width of the headers.  There is white space above, below and to the left of the rows.  Can can I fix this?

Thanks,
Mark

[Princy]

Hi Mark,

I couldn't replicate the issue, below is a sample code that i tried, which works fine at my end. Please try it, if this doesn't help, provide your code snippet.

ASPX:

<asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder>

C#:

RadGrid RadGrid1;
protected void Page_Init(object source, System.EventArgs e)
 {
    RadGrid1 = new RadGrid();
    RadGrid1.MasterTableView.DataKeyNames = new string[] { "OrderID" };
    RadGrid1.Skin = "Default";
    RadGrid1.PageSize = 15;
    RadGrid1.AllowPaging = true;
    RadGrid1.AutoGenerateColumns = true;
    RadGrid1.VirtualItemCount = 750;
    RadGrid1.MasterTableView.TableLayout = GridTableLayout.Fixed;
    RadGrid1.NeedDataSource += new GridNeedDataSourceEventHandler(RadGrid1_NeedDataSource);
    RadGrid1.ClientSettings.Scrolling.AllowScroll = true;
    RadGrid1.ClientSettings.Scrolling.EnableVirtualScrollPaging = true;
    RadGrid1.ClientSettings.Scrolling.UseStaticHeaders = true;
    RadGrid1.ClientSettings.Scrolling.SaveScrollPosition = true;
    this.PlaceHolder1.Controls.Add(RadGrid1);
 }

void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
 {
    RadGrid1.DataSource = GetDataTable("SELECT * FROM Orders");
 }

Thanks,
Princy

[Mark]

I have implemented custom paging that is only displayed for a certain subset of Users, but it still takes a long time to load 1000 records.  Virtual Paging, while nice, does not appear to be ideal.  Do you have any other suggestions?

Thanks,
Mark

[Princy]

Hi Mark,

Please go through the following forum post which discuss about your required scenarios.
http://www.telerik.com/community/forums/aspnet-ajax/grid/radgrid-performance-large-table-with-scrolling-filtering-sorting.aspx#1676508
Also please provide your code snippet so that i can replicate the issues you are facing.

Thanks,
Princy