Insert performace and vb.net
64578May 8 2006 — edited May 8 2006Hi Guys,
My application needs to do a lot of inserts in a short time (about 100,000) lines. I simply use the following vb.net code to insert the records.
Using InsertCommand As CoreLab.Oracle.OracleCommand = MyConnection.CreateCommand
InsertCommand.CommandText = "Insert INTO FDNY.CoreData (EventCode, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday) VALUES ('1234','1234','1234','1234','1234','1234','1234','1234')"
Try
InsertCommand.ExecuteNonQuery()
Catch ex As Exception
End Try
End Using
When I used the above code in SQL server express it was 10x faster. I think it has either to do with Indexing or tweaking Oracle XE. Can anyone help me with this. I am desperately trying to get rid of SQL server.
Thanks,
Stephane