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 索引,那么通常更好的做法是在批量插入之前定义它们,而不是事后才创建它们。