Very slow sort with DevExpress DataGrid

We get a 2 seconds lag when sorting a DevExpress.XtraGrid.Views.Grid.GridView binded on EntityList.
EntityList contain under 30 records (11 columns) and binding are done through XtraGridBindingDescriptor.

I commented all code in CustomDrawCell and RowCellStyle without any improvement.

Any idea on what can cause that lag?

Originally posted by f3rland I did a test using a DataSet instead of EntityList and I gain so much speed!!! Why EntityList binding is so slow? Is there a work around?

Is the grid displaying related entities (e.g., Order.Customer, etc.)?

Originally posted by f3rland Yes but I tried to include them as properties to master object too without any performance improvement.

I'm not sure I know what you mean by that, since the related objects would already be represented by relation properties generated by the Object Mapper.  But in any case, the most common cause of per performance in grid loading is that the related entities haven't been preloaded before you connect the EntityList to the grid. In that circumstances, populating each row of the grid requires one or more additional calls out to the data source to retrieve the related data.

Here's an article that describes the problem and the solution in detail:

     http://www.ideablade.com/DevForceClassic/TechTips/techtip_turbocharge_your_data_grid.htm

Let me know if that's not your problem.

Do you get the performance lag if you call ApplySort() directly on the EntityList?