Can I use this SQL Update faster

  • Thread starter Thread starter Lighting_dragon
  • Start date Start date
L

Lighting_dragon

I Use a loop to update many diferrent Row of a Table as so

For i=0 to Max
Try
MySQLCommand= New OleDbCommand(MySQLStatement, MyConn)
MySQLCommand.ExecuteNonQuery
' (1)***** System.Threading.Thread.Sleep(500)
Catch ex as Expition

End Try

Next

If i don't use Sleep (1)**** it will show an error that dababase is
locked. So I muss use Sleep to wait, but it works too long because I
have over 20 Rows to update.

How can i do that better .
 
* (e-mail address removed)-spam.invalid (Lighting_dragon) scripsit:
I Use a loop to update many diferrent Row of a Table as so

For i=0 to Max
Try
MySQLCommand= New OleDbCommand(MySQLStatement, MyConn)
MySQLCommand.ExecuteNonQuery
' (1)***** System.Threading.Thread.Sleep(500)
Catch ex as Expition

End Try

Next

If i don't use Sleep (1)**** it will show an error that dababase is
locked. So I muss use Sleep to wait, but it works too long because I
have over 20 Rows to update.
Click to expand...

.... I suggest to ask this question in a more appropriate group:

<URL:
Web interface:

<URL:http://msdn.microsoft.com/newsgroups/?dg=microsoft.public.dotnet.framework.adonet>
 
Hi Lighting

You can see what this will do for you.
(Playing with it of course)

mySQLCommand.CommandTimeout = 160

I hope this helps?

Cor
 
I have tested yor command. But it didn't work faster. However thank
for your help
 
Back
Top