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

GridView Perfomance for Database

3 Answers 102 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Christoph
Top achievements
Rank 1
Christoph asked on 30 Mar 2009, 11:54 AM
Hi,

I have a performance problem.
I load the GridView 2009 Q1 with Tabkeadapter fill method. The Data comes from a view on a ms sql server and contains over 500.000 rows.
The performance is really slow.

What is the best method to give the user the best performance.
Is the Method with the table adapter good?

I thought about only showing about 1000 rows and after applying a filter generating a new query to execute against the db and refill the tableadapter.

Please help,

Thank you very much

3 Answers, 1 is accepted

Sort by
0
Jack
Telerik team
answered on 30 Mar 2009, 01:46 PM
Hello Christoph,

Thank you for contacting us. The load time depends in this case on the connection speed between the server and your computer. The process can take a lot of time if there is a large number of records on the server and the connection is slow. You could improve the performance by using paging.

The following blog post demonstrates this technique:

Emulating Paging with RadGridView for WinForms and LINQ with 1 million records

I hope this helps. If you have other questions, feel free to ask.

Best wishes,
Jack
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.
0
Christoph
Top achievements
Rank 1
answered on 30 Mar 2009, 02:20 PM
Thanks a lot
I'll try that asap
0
Christoph
Top achievements
Rank 1
answered on 30 Mar 2009, 08:43 PM
Perfect, Exactly what i needed.

Thank You
Tags
GridView
Asked by
Christoph
Top achievements
Rank 1
Answers by
Jack
Telerik team
Christoph
Top achievements
Rank 1
Share this question
or