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

help with records

1 Answer 50 Views
GridView
This is a migrated thread and some comments may be shown as answers.
DragonBall
Top achievements
Rank 1
DragonBall asked on 20 Jan 2009, 02:05 AM
im using ragridview. the problem is if  i have 100,000+ records and i want to display update and delete it on the grid. how do i improve the performance of the loading time. im using linq to sql.

1 Answer, 1 is accepted

Sort by
0
Deyan
Telerik team
answered on 20 Jan 2009, 11:34 AM
Hello Manuel,

Thanks for your interest in RadControls for WinForms and RadGridView in particular.

One way to gain performance when using RadGridView with huge amounts of data is to load and show only separate portions of data. NET Framework 3.5 provides the infrastructure for such an implementation, as you already know - LINQ to SQL.

A simple scenario is to load some rows from the database and show them to the user. When the user requests another portion of the data, you query the database again and show the next data(page).

Please see this blogpost where a colleague of mine implemented paging in RadGridView:

Emulating Paging with RadGridView for WinForms

The paging is a good example of performance optimization and you can use this as a starting point and use the idea in order to optimize you application performance.

I hope this helps.

Do not hesitate to write back if you have any further questions or need assistance on the topic.

Greetings,
Deyan
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Tags
GridView
Asked by
DragonBall
Top achievements
Rank 1
Answers by
Deyan
Telerik team
Share this question
or