VB 6.0 - What is the fastest way to update a record?

I'm using VB 6.0 for my application and theres a time that i need to update one record to a particular table that contains 94862 rows and 21 columns..


I have already created a program to do the task but im not satisfy with the output I mean it is very slow in updating the record...

Here's my sample declaration:

Dim db as New AdoDB.Connection
Dim rs as New AdoDB.RecordSet
---------------------------------------------

db.CursorLocation = ADUseClient
Db.open(Myconnectionstring)

db.execute("Update transactionheader Set fcremarks = 'DELETED' where fnID = 1212")

db.close

Tha's my code.. so adddtional codes so that it would be faster to execute the task?

Thanks!

Check if your table you are trying to update is actively used.
Also try to Update Record through a Stored Procedure