Every article I have read states that using the database's inherent code, i.e. a stored procedure or running a sql statement to do the update is far better than using ADO as in your post. It certainly is quicker when you need to do multiple inserts although I have never seen benchmarks for just one row.
--
Joe
|