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.
對(duì)於經(jīng)過(guò)良好優(yōu)化的批量插入，由獲得每一行之上的一個(gè) X 鎖以及後來(lái)釋放該鎖引起的 CPU 開(kāi)銷(xiāo)是比較可觀的。 - 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 頁(yè)（256K）或者更大，緩沖池就不會(huì)被填滿，這樣的話對(duì)於該批量插入就衹有一次日志寫(xiě)（在提交時(shí)）。 - 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.
如果表上需要多個(gè)用戶定義的 XML 索引，那麼通常更好的做法是在批量插入之前定義它們，而不是事後才創(chuàng)建它們。