Grid view perfomance problem

[Chris Lynch]

I'm loading a  gridview from an oracle datareader approx 30,000 rows with 8 columns
and it taking almost a minute to load..  I have grouping and sorting enabled.
sample code is

Public

 

Sub SetGrid(ByVal grd As RadGridView)

 

 

Try

 

System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor

 

 

 

If Not dr Is Nothing Then

 

grd.MasterGridViewTemplate.LoadFrom(dr)

 

 

 

BestfitGrid(grd)

 

Else

 

 

Exit Sub

 

 

End If

 

 

Catch vbex As Exception

 

 

End Try

 

 

End Sub

would appriciate any direction in improving perfomance since I'm new to your software trying to justify purchase of Software

 

[Stefan]

Hello Chris Lynch,

Thank you for contacting us.

RadGridView shouldn't have any problems with loading 30,000 rows. I have attached a small application that loads 30,000 rows in a little more than a second (after loading the time is displayed in the TitleBar. Also you can see this same example in our Demo Application (Start -> Programs -> Telerik -> RadControls -> Run Demo).

Most likely you have a problem with your connection to the database, so please examine this option. 

Also what you can do is load the data from the data base into a DataReader and add the data from the DataReader to RadGridView, while measuring this time. If you experience slow performance in this case too, please write back to us.

If you have any other questions, do not hesitate to contact us.

Sincerely yours,
Stefan
the Telerik team

[Chris Lynch]

Stefan
Thanks for your reply, when  writing the support request I think I left out a couple of key points , thats what happen when you write them late in the day.

The issue is not database performance problem when I mentioned it was taking a minute to load I was talking Strictly after data reader was populated. The second point of forgot to mention is I working in VB.net v2008 and a trial verision of grid 2010.1.10.308
Chris

[Stefan]

Hi Chris Lynch,

Thank you for your reply.

As I said in my previous post, RadGridView could not be the reason for the delay, and I can't see such a reason in the code snippet that you provided. In order to provide you with further assistance I am going to need a sample project where we will be able to see the issue, and trace it. Please send it to us via the support ticketing system together with the exact steps which will guide us to reproduce the slowdown.

Looking forward to your reply.

 

Best wishes,
Stefan
the Telerik team