Remove the trigger when data is imported into Oracle

zhaozj2021-02-16  87

VC calls the ODBC interface to transfer data to Oracle, the speed is very slow, and 10 million data will take about one day to pass. Later, it was found that most of the TRIGGER executed while each time inserted a record. The purpose of this TRIGGER is to automatically add a field in a database to determine the uniqueness of the record. The solution is to manually add 1 to this unique field in the VC program (get the maximum value of this field before importing the data, and then add 1 operation on this). RESULTS: Now imports of 10 tens of thousands of data for about 7, 8 minutes, and the speed has increased by 100 times.

Conclusion: Trigger in the database is careful.

转载请注明原文地址:https://www.9cbs.com/read-14587.html

New Post(0)