blocks|key|3285939|text|您的问题的答案是Connection+Pooling功能。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3285940|最好是在需要时打开连接，访问数据，然后立即关闭并释放连接|3285941|确实存在一种特定的工作模式|3285942|using(SqlConnection+con+=+new+SqlConnection(.....))
{
+++...+do+your+work+with+the+database+here+....
}|code-block|syntax|javascript|3285943|using+statement确保在开口处创建的对象被关闭并放置在闭合大括号中。，即使数据库代码中出现异常也是如此。|style|BOLD|3285944|这并不意味着你不能尝试优化你的代码。例如，您可以将几个站点地图收集在一起，并在一次拍摄中编写它们，但通常最好遵循一个简单的工作模式，尽快完成工作，并为以后的优化而担心。|3285945|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/vstudio/8xx3tyca%2528v=vs.100%2529.aspx|1|http://msdn.microsoft.com/en-us/library/yh598w02.aspx^0|8|I|0|0|0|0|0|14|D|0|F|1|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@$A|13|B|14|1|15]]|C|$]]|$1|D|3|E|5|6|7|16|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|17|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|18|8|@]|9|@]|C|$K|L]]|$1|M|3|N|5|6|7|19|8|@$A|1A|B|1B|O|P]]|9|@$A|1C|B|1D|1|1E]]|C|$]]|$1|Q|3|R|5|6|7|1F|8|@]|9|@]|C|$]]|$1|S|3|-4|5|6|7|1G|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]|10|$5|V|W|X|C|$Y|11]]]]

The answer to your question is the <a href="http://msdn.microsoft.com/en-us/library/vstudio/8xx3tyca%28v=vs.100%29.aspx" rel="nofollow">Connection Pooling</a> feature.

It is always preferable to open the connection just when needed, access your data, close and dispose the connection immediately

Indeed a specific work pattern exists

<pre><code>using(SqlConnection con = new SqlConnection(.....))
{
 ... do your work with the database here ....
}
</code></pre>

The <a href="http://msdn.microsoft.com/en-us/library/yh598w02.aspx" rel="nofollow">using statement</a> ensures that the object created at the opening is closed and disposed at the closing braces. Even if an Exception occurs in database code.

This doesn't mean that you cannot try to optimize your code. For example you could gather a few of sitemaps together and write them in just one shot, but usually it is best to follow a simple work pattern, finish the work as soon as possible and worry for optimization later.

blocks|key|263217|text|您可以使用以下代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|263218|SqlConnection+conn;
try
{
++++conn+=+new+SqlConnection(_dbconnstr));
}
catch
{
++++//exceptions+are+bubbled
++++throw;
}
finally
{
++++//Dispose+is+always+called
++++conn.Dispose();
}|code-block|syntax|javascript|263219|希望这能有所帮助！|263220|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You can work with the following code :

<pre><code>SqlConnection conn;
try
{
 conn = new SqlConnection(_dbconnstr));
}
catch
{
 //exceptions are bubbled
 throw;
}
finally
{
 //Dispose is always called
 conn.Dispose();
}
</code></pre>

hope this helps!

blocks|key|263233|text|我通常在每次使用的时候打开和关闭连接。当周围有很多连接时，必须释放资源。如果你是唯一一个，你可以保留你的资源。注意设置超时连接。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|263234|祝你好运，伙计！|263235|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I usually open and close connection each time I use it.
Releasing resources must be done when there is many connections around.
If you are the only one, you might keep your resources.
Be aware of setting timeout connection.

Good luck guy!

blocks|key|1160207|text|最好是打开/关闭连接。将连接打开没有任何好处。ADO.NET+Connection+pooling+(默认情况下处于打开状态)将负责关闭哪个连接以及何时关闭。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1160208|来自MSDN|1160209|1160210|警告建议您始终在使用完连接后将其关闭，以便连接返回到池中。这可以使用Connection对象的Close或Dispose方法来完成。未显式关闭的连接可能不会添加或返回到池中。例如，如果连接已超出范围但尚未显式关闭，则只有在达到最大池大小且该连接仍然有效时，该连接才会返回到连接池。|blockquote|1160211|1160212|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx|1|http://msdn.microsoft.com/en-us/library/8xx3tyca%2528VS.71%2529.aspx^0|N|Q|0|0|2|4|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|F|3|-4|5|6|7|12|8|@]|9|@]|C|$]]|$1|G|3|H|5|I|7|13|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|14|8|@]|9|@]|C|$]]|$1|K|3|-4|5|6|7|15|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]|S|$5|N|O|P|C|$Q|T]]]]

It is better to open/close the connection. There is no benefits in kipping connection open. <a href="http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx" rel="nofollow">ADO.NET Connection pooling</a> (which is on by default) will take care of which connection to close and when.

From <a href="http://msdn.microsoft.com/en-us/library/8xx3tyca%28VS.71%29.aspx" rel="nofollow">MSDN</a>

<blockquote>
 CAUTION It is recommended that you always close the Connection when
 you are finished using it in order for the connection to be returned
 to the pool. This can be done using either the Close or Dispose
 methods of the Connection object. Connections that are not explicitly
 closed might not be added or returned to the pool. For example, a
 connection that has gone out of scope but that has not been explicitly
 closed will only be returned to the connection pool if the maximum
 pool size has been reached and the connection is still valid.
</blockquote>

blocks|key|1406161|text|如果您知道这将需要一段时间，那么如何写入本地数据表，然后当您达到阈值时，将所有记录写入数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1406162|或者甚至将信息写入本地文件(您选择的格式)，然后将该文件一次性写入数据库(如果您想每x个记录或y分钟写入一次，则可以多次写入。)|1406163|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

If you know it's going to take a while, what about writing to a local data table and then when you reach a threshold, write all the records to the database.

Or even write the info to a local file (format of your choice) and then write that file to the database in one shot (or multiple shots if you want to do it every x records or y minutes.)

I'm writing a program that generates Sitemaps. To avoid duplicates I'm using MSSQL Server to store links that are found. during this process It may read and write millions of links and the process of reading and writing may have very little gaps between them (I mean the time between each access to database is very tiny).

I want to know If I can open the connection when the program starts and close it at the end. please consider that creating some sitemaps may take days to finish. Or is it wise to open and close connection each time I want to access the db?

By the way, I'm using sql server locally.

Having sql connection open for a long time

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在写一个生成网站地图的程序。为了避免重复，我使用MSSQL Server来存储找到的链接。在这个过程中，它可能会读写数百万个链接，并且它们之间的读写过程可能会有很小的差距(我的意思是每次访问数据库之间的时间非常短)。我想知道我是否可以在程序启动时打开连接，并在结束时关闭它。请考虑创建一些网站地图可能需要几天的时间才...

问长时间打开sql连接
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问长时间打开sql连接EN