Hi

I am try to use Mysql AutoComplete Combobox
if I add this code to TextChanged then I need to Wait for some time

How can I use AutoComplete Combobox without Delay
the database have 117739 record


Code:
      con.Open()
        dt = New DataTable
        With cmd
            .Connection = con
            .CommandText = "select * from streets where streetname LIKE  '" & Txt_textbox.Text & "%'  ORDER BY streetname Asc"
        End With

        da.SelectCommand = cmd
        da.Fill(dt)

        Dim r As DataRow
        For Each r In dt.Rows
            Txt_textbox.AutoCompleteCustomSource.Add(r.Item("HEITINF").ToString)
            Txt_textbox.AutoCompleteMode = AutoCompleteMode.Suggest
            Txt_textbox.AutoCompleteSource = AutoCompleteSource.CustomSource
        Next
        'closing the connection
        con.Close()