单用户数据库连接最佳实践 [英] Single user database connection best practices

问题描述

有了MS Access单一使用者，

这是好的做法还是可以维持一个永久的连接？

psuedocode：

  app.start（）; 
 access.connect（）; 
 domanymanystuff（）; 
 access.disconnect（）; 
 app.exit（）; 
  

--- OR ----

  app.start（）; 
 access.connect（）; 
 doonetask（）; 
 access.disconnect（）; 
 ... 
 access.connect（）; 
 doanothertask（）; 
 access.disconnect（）; 
 ... 
 app.exit（）; 
  

？

解决方案<老实说，这并不重要，因为大多数数据连接是合并的，并将在你关闭后挂起来重复使用。

否则，即使使用单个用户数据库，也可以找到您的应用程序锁定

因此，请尝试：

 打开连接
开始事务
执行工作单元
提交事务
 ... 
开始事务
执行工作单元
提交事务
 ... 
开始事务
执行工作单元
提交事务
 ... 
关闭连接
  

With MS Access single user,

Is it good practice or okay to maintain a persistent connection throughout?

psuedocode:

app.start();
access.connect();
domanymanystuff();
access.disconnect();
app.exit();

--- OR ----

app.start();
access.connect();
doonetask();
access.disconnect();
...
access.connect();
doanothertask();
access.disconnect();
...
app.exit();

?

解决方案

Honestly it won't matter since most data connection are pooled and will hang around for reuse after you have closed them. You do want to make sure that your transactions are performed in a 'per unit of work' fashion.

Otherwise, even with a single user DB you could find your application locking itself out.

So, try this:

Open connection
Start transaction
Perform unit of work
Commit transaction
...    
Start transaction
Perform unit of work
Commit transaction
...    
Start transaction
Perform unit of work
Commit transaction
...
Close connection

这篇关于单用户数据库连接最佳实践的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！