DragonBall
Top achievements
Rank 1
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
0
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.
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.