Inserting errors into the database table occurs one at a time, which is not optimal. The real situation is the testing of legacy project, which generated more than 70 thousand errors. Testing went for more than an hour, and a significant part in my opinion is a record in the database. Using the bulk insert, can significantly increase the speed. In the current architecture, this is not possible, I suggest changing to ErrorWriter and ErrorReader.
Are there any other ideas?
Inserting errors into the database table occurs one at a time, which is not optimal. The real situation is the testing of legacy project, which generated more than 70 thousand errors. Testing went for more than an hour, and a significant part in my opinion is a record in the database. Using the bulk insert, can significantly increase the speed. In the current architecture, this is not possible, I suggest changing to
ErrorWriterandErrorReader.Are there any other ideas?