From f71a02229c1ba00fbecaead19256593ffb052753 Mon Sep 17 00:00:00 2001
From: duan <dante@isaints.net>
Date: 星期三, 21 八月 2024 17:18:40 +0800
Subject: [PATCH] 1
---
src/DIXPad.DAL/SQLDataProvider.cs | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/src/DIXPad.DAL/SQLDataProvider.cs b/src/DIXPad.DAL/SQLDataProvider.cs
index c80f5a8..b82a81f 100644
--- a/src/DIXPad.DAL/SQLDataProvider.cs
+++ b/src/DIXPad.DAL/SQLDataProvider.cs
@@ -230,7 +230,8 @@
}
transaction = connection.BeginTransaction();
bcp = new SqlBulkCopy(connection, SqlBulkCopyOptions.Default, transaction);
- bcp.BatchSize = 500;
+ bcp.BatchSize = 10000;
+ bcp.BulkCopyTimeout = 60;
//渚濇浣跨敤鏁版嵁搴撹繛鎺ュ鍏ユ暟鎹�
foreach (KeyValuePair<string, string> kv in sourceToDestinationFieldsMapping)
{
--
Gitblit v1.8.0