Wrox Home  
Search P2P Archive for: Go

  Return to Index  

ado_dotnet thread: ADO.net speed


Message #1 by "IQ" <iq@i...> on Wed, 17 Apr 2002 16:44:56
In lib_keycreate.asp page insert to database works very fast by using 
technique w/ADO Recordset object insert. For example on with a database of
764 products are parsed and re-indexed in 27sec (tbKeyword is filled with 
31052 records)
Now trying to port the code to .NET:
Using ADO DataSet and strict same data inserts the best performance I have 
got was 5000 records insert into tbKeywords in 22 seconds. this means that 
to insert 31052 records will take ~137 seconds (2min 28 sec) ! ! !
 
Anyone knows what is going on?

  Return to Index