sql如何避免插入并发_SQL批量插入并发和性能注意事项

sql如何避免插入并发

One of the challenges we face when using SQL bulk insert from files flat can be concurrency and performance challenges, especially if the load involves a multi-step data flow, where we can’t execute a latter step until we finish with an early step. We also see these optimization challenges with constraints as well, as fewer steps to complete a data flow results in saved time, but possibly less accurate data.

在从平面文件使用SQL批量插入时，我们面临的挑战之一可能是并发和性能方面的挑战，特别是如果加载涉及多步骤数据流，那么在完成第一步之前，我们无法执行后面的步骤。 我们还看到这些优化挑战也受到限制，因为完成数据流所需的步骤更少，可以节省时间，但数据准确性可能会降低。

We’ll look at solving concurrency issues, where we prevent a data flow process from accessing data too early in a central repository situation. In addition, we’ve also looked at some techniques to specify options which ensure that our business rules and constraints are followed while data are being inserted. We’ll also look a