This is a migrated thread and some comments may be shown as answers.

Reduce time of datas'load

7 Answers 74 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Thierry Treunet
Top achievements
Rank 1
Thierry Treunet asked on 07 Jul 2008, 03:13 PM
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

7 Answers, 1 is accepted

Sort by
0
Vlad
Telerik team
answered on 07 Jul 2008, 03:29 PM
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
0
Thierry Treunet
Top achievements
Rank 1
answered on 07 Jul 2008, 04:25 PM
What i wanted to now is :

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

Thanks

Thierry
0
Vlad
Telerik team
answered on 07 Jul 2008, 04:29 PM
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
0
Thierry Treunet
Top achievements
Rank 1
answered on 07 Jul 2008, 04:44 PM
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
0
Vlad
Telerik team
answered on 07 Jul 2008, 05:06 PM
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
0
Thierry Treunet
Top achievements
Rank 1
answered on 08 Jul 2008, 07:46 AM
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
0
Shinu
Top achievements
Rank 2
answered on 08 Jul 2008, 10:54 AM
Hi Thierry,

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

Shinu.
Tags
Grid
Asked by
Thierry Treunet
Top achievements
Rank 1
Answers by
Vlad
Telerik team
Thierry Treunet
Top achievements
Rank 1
Shinu
Top achievements
Rank 2
Share this question
or