[問題] 寫入資料庫的速度差異..
我要將開啟檔案時，使用者選取的檔案存入資料庫..
那麼我該怎麼Insert to資料庫比較快速呢??
目前的作法是
foreach (string FileName in openFileDialog1.FileNames)
{
string OracleInsert_Filenames = @"INSERT INTO apps.test
(receipt_number, file_name, created_by, creation_date,
last_updated_by,last_update_login, last_update_date ) VALUES
('" + Number + "','" + FileName + "', 0, SYSDATE, 0, 0, SYSDATE)";
OracleCommand InsertFileNamesComm = new OracleCommand
(OracleInsert_Filenames, OracleDB_Wafer);
InsertFileNamesComm.ExecuteNonQuery();
}
還是說，先把檔案名稱存到陣列中，然後再一次把檔案Insert...
請問哪一種在執行速度上會比較快呢??
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 118.171.198.138
→
09/13 09:42, , 1F
09/13 09:42, 1F
→
09/13 13:15, , 2F
09/13 13:15, 2F
推
09/13 13:21, , 3F
09/13 13:21, 3F
→
09/13 23:21, , 4F
09/13 23:21, 4F
推
09/14 09:14, , 5F
09/14 09:14, 5F
→
09/14 09:15, , 6F
09/14 09:15, 6F
→
09/14 09:16, , 7F
09/14 09:16, 7F
→
09/14 09:16, , 8F
09/14 09:16, 8F
C_Sharp 近期熱門文章
PTT數位生活區 即時熱門文章
