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)