DataGridView性能改进

Question

我最近开发了一个应用程序，上面有一个datagridview。经过几分钟的测试后，我注意到性能非常差，在渲染数据时存在问题(滞后，操作缓慢)，我还在寻找解决方案，如启用虚拟模式等。无济于事，你能建议或帮助我有一种方法，我可以提高性能和模式这段代码。

下面是我的代码：

private void LoadTable()
    {
        var connection = Connection.prevzemiKonekcija();

        var adapter1 = new MySqlDataAdapter();
        var sqlSelectAll = "SELECT * from prodavnica.artikli";
        adapter1.SelectCommand = new MySqlCommand(sqlSelectAll, connection);

        var table = new DataTable();
        adapter1.Fill(table);

        var bajndsors = new BindingSource();
        bajndsors.DataSource = table;


        dataGridView1.DataSource = bajndsors;

        dataGridView1.RowsDefaultCellStyle.BackColor = Color.Linen;
        dataGridView1.AlternatingRowsDefaultCellStyle.BackColor =
            Color.Cornsilk;


        /*
        dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
        dataGridView1.AutoResizeColumns();


        dataGridView1.RowsDefaultCellStyle.BackColor = Color.Bisque;
        dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
        dataGridView1.CellBorderStyle = DataGridViewCellBorderStyle.None;

        dataGridView1.DefaultCellStyle.SelectionBackColor = Color.Red;
        dataGridView1.DefaultCellStyle.SelectionForeColor = Color.Yellow;

*/


        dataGridView1.Columns[0].HeaderText = "РЕД.БР";
        dataGridView1.Columns[1].HeaderText = "ШИФРА";
        dataGridView1.Columns[2].HeaderText = "НАЗИВ";
        dataGridView1.Columns[3].HeaderText = "НАБАВНА ЦЕНА";
        dataGridView1.Columns[4].HeaderText = "ПРОДАЖНА ЦЕНА";
        dataGridView1.Columns[5].HeaderText = "КОЛИЧИНА";
        dataGridView1.Columns[6].HeaderText = "ДАНОК";
        dataGridView1.Columns[7].HeaderText = "ОПИС";
        dataGridView1.Columns[8].HeaderText = "ДОЛГ ОПИС";
        dataGridView1.Columns[9].Visible = false;
        dataGridView1.Columns[10].HeaderText = "ЕДИНИЦА";
        dataGridView1.Columns[11].HeaderText = "ПРОФИТ";
        dataGridView1.Columns[12].HeaderText = "ПРОИЗВОДОТЕЛ";

            this.dataGridView1.VirtualMode = true;

            //dataGridView1.Columns["MakArtikal"].Visible = false;


                    connection.Close();
}

Answer 1

使用SqlDataReader要快得多，请检查https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/retrieving-data-using-a-datareader