Reduce time of datas'load

[Thierry Treunet]

Hello,

I use a RADGRID with a SQLDatasource.

My datasource use the query "select field1, field2 from Matable" and my grid has to list the 50 first recordings because the propertie pagesize is "50".
But the time of data's load is equal than time which is necessary to load the totality of the recordings.

Is it possible to load a "top 50" on each page?

Thank you

[Vlad]

Hi Thierry,

You can use LinqDataSource in .NET 3.5 to achieve this or ObjectDataSource for .NET 2.0. SqlDataSource does not support server-side paging.

Other possible solution is to assign DataSource for the grid directly using NeedDataSource event similar to first grid this example:
http://www.telerik.com/DEMOS/ASPNET/Prometheus/Grid/Examples/Programming/CustomPaging/DefaultCS.aspx

Kind regards,
Vlad
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Thierry Treunet]

What i wanted to now is :

how to reduce the time of generation of datasources in my grid ?

Thanks

Thierry

[Vlad]

Hello Thierry,

I'm not sure of what you mean by "the time of generation of datasources in my grid". Can you please elaborate?

Greetings,
Vlad
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Thierry Treunet]

I want my datas to appear more quickly in my grid , I would like to know how to reduce the time between the moment of the data acquisitions and their visualization on the grid.

I found it to long , is there a solution ?

Regards

Thierry

[Vlad]

Hello Thierry,

You can use custom paging also called server-side or data-base paging. Please check the example from my previous reply.

Greetings,
Vlad
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Thierry Treunet]

Thank you it is this but I forgot to make the properties enableCaching as true for my SqlDatasource so the time of load was important.

Thank you for your reply

Thierry

[Shinu]

Hi Thierry,

You can also refer the following help article which explains how to optimize the Grid performance.
Client/server grid performance optimizations

Shinu.