connecting VIA ADO.net slow after deployment

[brucelim80]

hi all,
I am a newbie in VB.net.
Can someone help me with this problem?

I had used oledb connection to extract data from database and dump it into items of combo box. It appear fast on the PC used for developing the application.

example

Dim strsql As New OleDbCommand("SELECT * FROM PROBLEMDB WHERE SYSTEMID = '" _
& selectedsys & "' AND ProbCat='" & procat & "'", myConnects)
        myConnects.Open()
        Dim reader As OleDbDataReader = strsql.ExecuteReader

        Do While reader.Read

            prodetail.Items.Add(reader.Item("Probdetail").ToString)

        Loop
        reader.Close()

However, when i compile to a installation file and installed on to another similar configuration PC, it is very slow.

The items added to the combo box appear to be lagging.


Can anyone know how to solve this problem?

What do i need to add into the deployment folder (Assembly/application folder) ?


Thanks

 

[Arg81]

when you created the compiled executable, you did compile a release and not a debug program??

if you compiled a debug (normally set as default) then yes, it will run MUCH slower than if it's complied as release....