GridView Perfomance for Database

[Christoph]

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

[Jack]

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.

[Christoph]

Thanks a lot
I'll try that asap

[Christoph]

Perfect, Exactly what i needed.

Thank You