I have a grid with 30'000 rows, 60 Columns. When I want to scroll horizontally the CPU (E6850 at 3GHz) goes up and the scrolling blocks for a few seconds. I intercept no events from the grid. Are there any settings to avoid this heavy CPU-Load?
Turnig off SyncWithCurrencyManager did'nt help.
The gird displays customer-adresses (30'000), each adress can have a special delivery- and billing-adress, and a reference to a main adress (i.e. always a self-reference to the same table with 30'000 rows).
To help the user choose the right adress, I diplay them in an UltraComboEditor. ValueMember is the internal ID of the customer, in the DisplayMember I show the customer-number with the customer name:
Data: ID is 1234, customer-number ist 100002, name ist 'My Customer'Combobox: Value = 1234, Text = '100002 MyCustomer'
Maybee there is an other way to provide this functionality..
Manuel
So each new editor in at least one column is bound to a DataTable with 30,000 rows? Are these all bound to the same DataTable, including the grid? One solution that might would would be to turn off the SyncWithCurrencyManager of the grid to see if that speeds up anything. My guess as to what's happening is that when the grid needs to render the values in the columns with those large editors, it needs to look up the value in the list to pull out the appropriate DisplayMember and ValueMember, but I'm not entirely sure offhand.
-Matt
I use 8.1 and Vista and XP. In several columns I use UltraComboEditors as editorcontrols with 30'000 entries. The scrolling seems to stagnate when these columns come into view.
UltraGridColumn col = mGrid.DisplayLayout.Bands[iBand].Columns[sCol];UltraComboEditor ed = new UltraComboEditor();EditorButton bt = new EditorButton();ed.ButtonsRight.Add(bt);ed.DropDownButtonDisplayStyle = Infragistics.Win.ButtonDisplayStyle.Never;col.EditorControl = ed;ed.DataSource = table; // a DataTable with 30'000 entriesed.DisplayMember = table.Columns[1].ColumnName;ed.ValueMember = table.Columns[0].ColumnName;ed.BindingContext = mGrid.BindingContext;ed.DataBind();
There were a number of performance improvements made in 7.3; what version are you using? I just quickly created a DataTable with 60 columns and 30000 rows and my CPU usage never went past 30%, with the scrolling being pretty smooth. With this being said, things like transparancies and complex rendering will slow down your scrolling. Can you provide any additional information about your grid, or are you seeing this with the default settings?