UIvirtualization mode

[User (Old forums)]

#15461 |

Hello,

I have a really large dataset to display in the grid. for about 129.000 rows.

While using trial version 3.6 i do not see any difference in performance.
I use an PostgreSQL database.

This is a snippet of my quick and dirty testprogram in Vb 2005 express edition

Init = True
insertRow.Visible = True
Dim Value As UIVirtualizationMode = UIVirtualizationMode.Cells
insertRow.FitHeightToEditors = True
GridControl1.FixedHeaderRows.Add(insertRow)
insertRow.BackColor = Color.LightGreen
LoginForm1.ShowDialog()
Connect_DB()
SQL_comm(“select * from store.gebruikers”)

DS = New DataSet
DA.SelectCommand = cMd
DA.Fill(DS, “gebruikers”)
GridControl1.BeginInit()
GridControl1.UIVirtualizationMode = Value
GridControl1.DataSource = DS

GridControl1.DataMember = “gebruikers”

GridControl1.EndInit()

…..

Please tell me how to optimize the code for bettter performance.

Thanks

Martijn Pijpers

Imported from legacy forums. Posted by Martijn (had 1987 views)

[User (Old forums)]

#15462

Your code looks fine. If you see no difference with the new version, it may be that somewhere later in your code, you set something on the cells, which “de-virtualizing” the cells. Are you doing anything special after the EndInit? Do you subscribe to any events that is not shown in the code snippet?

Imported from legacy forums. Posted by André (had 2885 views)

[Author]

Posts