This object was bound to A Devexpress Grid. The time it takes to show query result on this grid is 1:40 (mm:ss)

The same object was bound to DataGridView. The result is nearly 3 (seconds)

I wonder why do I encounter with there is big difference ? Everyone test this condition easily.

I had the same problem with an Infragistics Grid. The time of loading was 25 times slower than the DataGridView. I found an option in the Infragistics grid

this.grid.DisplayLayout.LoadStyle = Infragistics.Win.UltraWinGrid.LoadStyle.LoadOnDemand;

By default, this option is set on PreloadRows. Now with the property set on LoadOnDemand, my grid loads in 600 ms.

So I advise you to search the same kind of option in the DevExpress Grid. It may help you

David