[Solved] Grid Data Issues

[AdamL]

I am looking for best practices and the answer to where I am going wrong.  I am creating the grid with bound columns (not autogenerated).  I have enabled paging.  I am querying an Oracle database and returning about 18,000 rows.

I placing these returing rows into a datatable.  I am setting that datatable to the grid datasource in the NeedDataSource Event. 

Here is my problem with the grid:

1.  The paging and sorting are not working.  The grid blanks out when I attempt to goto the next page or sort a column.

Here is my questions:

1.  Is there a better way to handle this than the datatable route that I am using...It takes too long to fill the datatable with 18,000 records... While I know this is not an issue with the Telerik controls, is there a best-practice that I can use to increase performance.

<EDIT>
<update>  I made a datasource for my data (5 of them since I have 5 grids).  The grid paging works.  However, the page initially takes 45 seconds to load.  and takes another 45 seconds everytime the user goes to the next page on the grid.

New Questions:

1.  Why is paging taking so long... What can I do to optimize it so it does not take 45 seconds to change grid pages.

2.  Is there a pre-load splash screen that I can display while the page initially loads.  My users are ok with an initial wait but, I have to do something about the grid pages.
</EDIT>

Thanks in advance

- Adam

[Princy]

Hi,

Go through the following help article .
Client/server grid performance optimizations

Thanks
Princy.

[AdamL]

Thank you for the link.  I will definitely look into some of those options.  However, for the paging issues I am having, is custom paging the best option.  At this point, I am pulling 20,000+ records into a SqlDataSource at load. 

That SqlDataSource is the datasource for a radGrid.  I am fine with the initial load time but, to take that long on each grid page is not feasible.  I will look at the custom paging example but, is there any other advice on how I can implement a system that will allow for quick paging through 20,000 records from a Oracle database.

Thanks,

- Adam

[Vladimir]

Adam,

Using custom paging you can handle very large sets of data - in your case most probably ObjectDataSource will do the work. You can check also these examples where the grid is bound using ObjectDataSource and LinqDataSource:

http://www.telerik.com/demos/aspnet/prometheus/Grid/Examples/Programming/CustomPaging/DefaultCS.aspx

http://www.telerik.com/demos/aspnet/prometheus/Grid/Examples/GeneralFeatures/ASPNET35/DefaultCS.aspx

In the LinqDataSource example the grid is bound to 1 mil. records table from  SQL Server.