但是我发现使用cmd.ExecuteNonQuery()向数据库发送数据很慢,那么如何提高数据传输的速度呢?现在它大约是20,000行/分钟,无法满足性能要求。using @datatable src on cvr.PackageName =src.PackageName and cvr.env_cloud_roleInstance = src.env_cloud_roleInstancewhen matched and cvr.env_time<src.env_time then
upd
{ new CustomClass { color = "Red", type = "cvrnew CustomClass { color = "Green", type = "lcd" },
new Customclass { color = "Green", type = "cvrnew Cust