StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » DevExpress grid data loading speed

DevExpress grid data loading speed

Peter Jones — Tue, 29 May 2007 08:53:31 GMT

Hi,

I seem to remember a comment on the forum regarding DevExpress grid data load speed being a bit on the slow side. Hopefully the speed I'm seeing isn't typical of a DevExpress grid and we have a problem somewhere.

I have a single grid on a form that shows all 600 records in a table. The data source is a stored procedure which, if I run in Query Analyser returns all rows immediately. However, in the grid, I see a page full of rows as soon as the grid displays and the record count is 1 of 600 but then I get a wait cursor for 40 seconds. I have no idea what's going on in that 40 seconds but could it be that DevExpress is simply loading its data table?

Cheers, Peter

RE: DevExpress grid data loading speed

StrataFrame Team — Tue, 29 May 2007 08:53:31 GMT

Chan, If you are trying to show 30,000 records in the grid using a business object and the BusinessBindingSource, you might try to set the business object's .CurrentView or .CurrentDataTable (which will actually set the .CurrentView ;) using the IListSource interface...) as the DataSource for the grid and see if the performance improves.

RE: DevExpress grid data loading speed

Trent L. Taylor — Mon, 28 May 2007 18:09:26 GMT

LOL :D ...that'll do it every time! Glad you found your problem.

RE: DevExpress grid data loading speed

Peter Jones — Mon, 28 May 2007 16:50:08 GMT

Hi Guys,

Thanks for the feedback - my mistake - I had left a piece of debug code in our DAL wrapper and the FillByStoredProc was executed 100 times on each (Win) form load so the speed is, in actual fact, quite good.

Cheers, Peter

RE: DevExpress grid data loading speed

Chan — Mon, 28 May 2007 12:01:25 GMT

Hi,

I tried to load/show 10,000 records with 20 columns to DevExpress XtraGrid. It takes me 4 secs. However, if I load 30,000 records it would slow down to 1 min 7 secs.

Is it consider slow compare to Infragistic or other grid?

Please advice.

Thank you

RE: DevExpress grid data loading speed

Trent L. Taylor — Mon, 28 May 2007 09:51:00 GMT

We no longer use DevExpress grid and use the Infragistics grid which has been extremely fast. It is possible that the grid is slowing you down here, but 40 seconds seems like a long time. I would try using a regular .NET DataGridView to see if the speed problem persists, if not, then I think you have your answer.

One really good tool to find out where speed issues exist within your application is the Ants Profiler (http://www.red-gate.com/products/ants_profiler/index.htm) which will give you an exact break down of where the speed issues exist within your code...this is VERY helpful when trying to figure this type of thing out.