Hello,
I would like to bind the gridview control, on a VB.Net form, to an Oracle 11g database that has millions of records.
Can anybody tell what would be the performance in this case? Does grid a have 'pagination' or a buffering feature that would allow a fast load/scrolling?
I have a Windows utility called Oracle SQL Developer (from ORACLE Corp.) that does a similar job, i.e. can be used to browse a table that has millions of records and it works super fast.
Does Telerik grid have a similar performance? I didn't install it yet because I would research for a different product in case the performance is slow.
Regards,
M. R. - Toronto
3 Answers, 1 is accepted
0
Hi Mircea Rusu,
Thank you for contacting us.
I would like to bind the gridview control, on a VB.Net form, to an Oracle 11g database that has millions of records.
Can anybody tell what would be the performance in this case? Does grid a have 'pagination' or a buffering feature that would allow a fast load/scrolling?
Well, several millions is a lot. I suggest using the Virtual Mode where only the currently visible rows are loaded. This will be pretty easy to implement if you do not need filtering, sorting, hierarchy and will be quite fast i.e. you will just have a handful of records at any given moment. Unfortunately we do not support pagination although there is a blog post demonstrating how you can work-around that. There is also a feature called fast scrolling -- when you scroll the scrolling area is not refreshed until the scrollbar is released which improves scrolling performance dramatically when there are many rows.
I have a Windows utility called Oracle SQL Developer (from ORACLE Corp.) that does a similar job, i.e. can be used to browse a table that has millions of records and it works super fast. Does Telerik grid have a similar performance? I didn't install it yet because I would research for a different product in case the performance is slow.
Well, if you use virtual mode it should be similar. But again in that case, you lose the automatic filtering, sorting, etc. You can still implement it but you need to use custom code and it will slow down things even if done in your data base e.g. filtering.
I hope that this answers your questions in full. Do not hesitate to write me back if you have further questions.
Sincerely yours,
Nick
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Thank you for contacting us.
I would like to bind the gridview control, on a VB.Net form, to an Oracle 11g database that has millions of records.
Can anybody tell what would be the performance in this case? Does grid a have 'pagination' or a buffering feature that would allow a fast load/scrolling?
Well, several millions is a lot. I suggest using the Virtual Mode where only the currently visible rows are loaded. This will be pretty easy to implement if you do not need filtering, sorting, hierarchy and will be quite fast i.e. you will just have a handful of records at any given moment. Unfortunately we do not support pagination although there is a blog post demonstrating how you can work-around that. There is also a feature called fast scrolling -- when you scroll the scrolling area is not refreshed until the scrollbar is released which improves scrolling performance dramatically when there are many rows.
I have a Windows utility called Oracle SQL Developer (from ORACLE Corp.) that does a similar job, i.e. can be used to browse a table that has millions of records and it works super fast. Does Telerik grid have a similar performance? I didn't install it yet because I would research for a different product in case the performance is slow.
Well, if you use virtual mode it should be similar. But again in that case, you lose the automatic filtering, sorting, etc. You can still implement it but you need to use custom code and it will slow down things even if done in your data base e.g. filtering.
I hope that this answers your questions in full. Do not hesitate to write me back if you have further questions.
Sincerely yours,
Nick
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
M. R.
Top achievements
Rank 1
Rank 1
answered on 05 Mar 2010, 07:52 PM
Thank you for the information Nick. Is there any chance to enhance the grid in the future in order to work with my scenario and be able to sort/filter etc without any custom code?
Regards,
Mircea
Regards,
Mircea
0
Hello Mircea Rusu,
Thank you for contacting us back. Well, that contradicts with the idea of virtual mode and therefore we cannot enhance virtual mode with that functionality. For example, in order to do filtering we need all data base records which means that all rows have to be retrieved from the data base.
Filtering/Sorting are working automatically in bound mode when virtual mode is not used. You can test the performance in that mode.
Do not hesitate to write me back if you have further questions.
Kind regards,
Nick
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Thank you for contacting us back. Well, that contradicts with the idea of virtual mode and therefore we cannot enhance virtual mode with that functionality. For example, in order to do filtering we need all data base records which means that all rows have to be retrieved from the data base.
Filtering/Sorting are working automatically in bound mode when virtual mode is not used. You can test the performance in that mode.
Do not hesitate to write me back if you have further questions.
Kind regards,
Nick
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.