I am using linqdatasource to bind the the radgrid. In the linqdatasource I am specifying a view from the database. If i run the view in query analyzer it takes 3 to 4 sec.
Navigating the grid using page numbers takes around 2 secs which is fine.
Problem here is when I enter search criteria in the filter box it would take more than 7 sec. Any reason why it would happen?
could also clarify how linqdatasource works internally. If I click a page no. does it execute the view again and show only the appropriate records?
Navigating the grid using page numbers takes around 2 secs which is fine.
Problem here is when I enter search criteria in the filter box it would take more than 7 sec. Any reason why it would happen?
could also clarify how linqdatasource works internally. If I click a page no. does it execute the view again and show only the appropriate records?
1 Answer, 1 is accepted
0
Hello Cognos,
Please refer to this online example which illustrates optimized performance techniques incorporated in the ASP.NET 3.5 build of RadGrid. The control takes advantage of the new LINQ (Language Integrated Query) syntax introduced in ASP.NET 3.5 and performs aggregate calculations or executes sorting/filtering/paging operations by means of native LINQ expressions.
This technique significantly reduce the time necessary to process these actions "behind the scenes" and allows you to handle millions of records within a few milliseconds.
Greetings,
Pavlina
the Telerik team
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Follow the status of features or bugs in PITS and vote for them to affect their priority.
Please refer to this online example which illustrates optimized performance techniques incorporated in the ASP.NET 3.5 build of RadGrid. The control takes advantage of the new LINQ (Language Integrated Query) syntax introduced in ASP.NET 3.5 and performs aggregate calculations or executes sorting/filtering/paging operations by means of native LINQ expressions.
This technique significantly reduce the time necessary to process these actions "behind the scenes" and allows you to handle millions of records within a few milliseconds.
Greetings,
Pavlina
the Telerik team
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Follow the status of features or bugs in PITS and vote for them to affect their priority.