unity-orm
unity-orm copied to clipboard
Add Transaction to InsertAll, that makes the process speed up
public void InsertAll<T>(T[] objects){
var desc = Registory.GetClassDesc<T>();
foreach(T obj in objects){
string insert = SQLMaker.GenerateInsertSQL(desc,obj);
database.ExecuteNonQuery(insert);
}
}
change to
public void InsertAll<T>( T[] objects ) {
var desc = Registory.GetClassDesc<T>();
database.ExecuteNonQuery( "BEGIN TRANSACTION;" );
foreach (T obj in objects) {
string insert = SQLMaker.GenerateInsertSQL( desc, obj );
database.ExecuteNonQuery( insert );
}
database.ExecuteNonQuery( "COMMIT;" );
}