Can I use this SQL Update faster

[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 .
Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

[Herfried K. Wagner [MVP]]

* as*@asd-dot-com.no-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.

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

<URL:news://news.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

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

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

[Cor Ligthert]

Hi Lighting

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

mySQLCommand.CommandTimeout = 160

I hope this helps?

Cor

[Lighting_dragon]

I have inserted it , but it did'nt work faster. However thank for your
help
Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

[Lighting_dragon]

I have tested yor command. But it didn't work faster. However thank
for your help
Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com