Visual Studio中DataGridView调试加载缓慢问题求助

问题现象 #

• 在Visual Studio 2022的Debug模式下运行应用时，Resident's Information DatagridView 加载耗时极长
• 直接运行Debug文件夹下的外部.exe文件时，DataGridView加载速度快、无延迟

已尝试的无效操作 #

• 清理项目/解决方案
• 重新构建项目

DataGridView填充代码 #

mySQLCommand.CommandText = "Select * From residents" & (IIf(txtSearchResident.Text.Trim = "" Or txtSearchResident.Text = "Type in your search", " ", " WHERE first_name LIKE @resident_name OR middle_name LIKE @resident_name OR last_name LIKE @resident_name")) & " order by first_name asc limit 30 OFFSET " & (((CInt(Me.txtPageNoResident.Text)) - 1) * 30)
mySQLCommand.Parameters.AddWithValue("@resident_name", "%" & txtSearchResident.Text & "%")
mySQLReader = mySQLCommand.ExecuteReader

While mySQLReader.Read
        Dim middle, ext As String
        If mySQLReader!middle_name <> DBNull.Value Then
            middle = mySQLReader!middle_name + " "
        Else
            middle = ""
        End If

        If mySQLReader!ext_name <> DBNull.Value Then
            ext = mySQLReader!ext_name
        Else
            ext = ""
        End If

        datagrid.Rows.Add(New String() {(mySQLReader!first_name + " " + middle + mySQLReader!last_name + " " + ext), mySQLReader!sex, mySQLReader!is_voter, mySQLReader!contact_no})

End While

开发环境 #

• 语言：Visual Basic .Net
• IDE：Visual Studio 2022
• 数据库：XAMPP搭建的MySQL

内容的提问来源于stack exchange，提问作者Jayvee Jimenez