bs.datasource = dt (too slow) 400record takes 3seconds

[jaasaria]

hi guys , i have a problem with my loading/refresh record in my form.
i have only almost 500 record and take so long before refreshing/display the data. i have a user input form where user enter their record and while saving(direct to the database) and refreshing data i just call only my function getrec ().

pls give me some idea to fix this problem.
pls take a look

Dim ActiveTable As New DataTable
Private Sub frmRef_Userlist_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        getrec
End Sub
Private Sub dtBind(ByVal dt As DataTable)
        'slow start here
        bs.DataSource = ActiveTable 'binding
        'slow end here

        bs.MoveFirst()
        bn.BindingSource = bs
        dgv1.DataSource = bs 'listview
        CloseMainCon() 'closing connection

End Sub
private sub getrec
       SqlString = "SELECT " & Tbl_Fields & " FROM " & Tbl_Name & " order by xcode desc"
        ActiveTable = OpenRSTable(SqlString)
        dtBind(ActiveTable)
end sub

`

[Begginnerdev]

You can emplement some form of Data Paging to speed the process up.

For exmaple: Query in 100 records at a time then post those out to your control.

If the user starts scrolling the control, and is nearing the bottom - add another 100. Rinse and repeat!

[jaasaria]

can you provide any code/link. just for my reference.
also even 400 record it is normal to react that kind of slowdown?

[ryanjayson]

what is bs? try to clear if its a container then fill it again or try Begginnerdev's suggestion.

[deceptikon]

what is bs?

BindingSource

[Begginnerdev]

even 400 record it is normal to react that kind of slowdown?

From my experience (limited) I have had 700+ records queried in take less than a second. (All codebehind using a data reader/adapter and writing my own fill functions.)