bulk insert
英汉例句
- For a well optimized bulk insert, the CPU cost of obtaining and later freeing an X lock on every row can be significant.
對於經過良好優化的批量插入,由獲得每一行之上的一個 X 鎖以及後來釋放該鎖引起的 CPU 開銷是比較可觀的。 - By raising the value of LOGBUFSZ to 64 (256K) or more, the log buffer will not fill, and there will only be one log write (at commit) for the bulk insert.
如果將 LOGBUFSZ 的值增加到 64 頁(256K)或者更大,緩沖池就不會被填滿,這樣的話對於該批量插入就衹有一次日志寫(在提交時)。 - If you need multiple user-defined XML indexes on your table, it is typically better to define them before the bulk insert rather than creating them afterwards.
如果表上需要多個用戶定義的 XML 索引,那麽通常更好的做法是在批量插入之前定義它們,而不是事後才創建它們。