winform小程序向数据表插入的问题
插入的量大时，就挂掉了，1万条可以，10万条直接卡住，挂掉了
以下是主要代码： 怎么回事啊
public static bool OperateDatasWithTransaction(List<string> sqlList) { OracleConnection myConnection = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnStrOrcl"]); myConnection.Open(); OracleCommand myCommand = myConnection.CreateCommand(); OracleTransaction myTrans; // Start a local transaction myTrans = myConnection.BeginTransaction(IsolationLevel.ReadCommitted); // Assign transaction object for a pending local transaction myCommand.Connection = myConnection; myCommand.Transaction = myTrans; try { foreach (string item in sqlList) { myCommand.CommandText = item; myCommand.ExecuteNonQuery(); } myTrans.Commit(); return true; } catch (Exception) { myTrans.Rollback(); return false; } finally { myConnection.Close(); }