Home Forums WinForms controls Xceed Grid for WinForms UIvirtualization mode

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • User (Old forums)
    Member
    Post count: 23064
    #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)
    Member
    Post count: 23064

    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)

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.