For this, you need to keep a log; bulk load and import programs often log to a file, but inside the database you need to use a table.
为此,需要维护一个日志;批量装载和导入程序常常将日志写入一个文件,但是在数据库中需要使用一个表。
Think of the access log of a web server where the IP address and browser agent are repeated in every row, taking up space but simplifying bulk processing.
想一想web服务器的访问日志,其中每一行都重复了IP地址和浏览器代理,这虽然占用了空间但却简化了批量处理。
As with bulk loads from a file, therefore, it is better to issue a COMMIT statement periodically, so the logical log files can be flushed.
因此,在从文件进行批量装载时,最好是定期发出commit语句,这样就可以刷新逻辑日志文件。
应用推荐