单用户数据库连接最佳实践

本文介绍了单用户数据库连接最佳实践的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

有了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