将使用事务减少sql server进程/线程？ [英] will using transactions reduce sql server process / threads?

问题描述

大家好。，



是否可以通过在sql server中创建插入查询的事务过程来减少进程或线程的数量

Hi all.,

Is it possible to reduce the number of process or threads by creating transaction procedure for insert query in sql server

推荐答案

事务与线程无关。尝试更详细地解释问题，是否插入批量记录，插入中是否有很多进程？为什么要减少线程，似乎是一个非常深奥的要求。

Transactions have nothing to do with threads. Try explaining the problem with a little more detail, are you inserting bulk records, are there a lot of processes in the insert? Why do you want to reduce the threads, seems a very esoteric requirement.

SQL事务与性能/资源问题无关。它曾经将独立的SQL查询组合在一起，使它们成为一个单元，如果在任何不同的部分发生错误，它将能够取消整个...

SQL transaction has nothing to do with performance/resource issues. It used to combine together independent SQL queries to make them a single unit, that will enable to cancel the whole if error occurred in any of the different parts...

这篇关于将使用事务减少sql server进程/线程？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！