You are viewing limited content. For full access, please sign in.

Question

Question

Database access account

Forms
Updated September 15, 2016
asked on September 13, 2016 • Show version history

Does Forms use the service account for all database access?  For a forms lookup for example, does it just use the one account to open/close that connection for a database call?  This is as opposed to a pool of connections that can be configured to scale with use to avoid having to open and close connections.  Just wondering how that works.

 

Thanks

 

0 0

Replies

replied on September 14, 2016

Hi, 

Routing engine uses the connection string in the RoutingEngineServiceHost and Web service uses the connection string in Web.config.   Both are configured when you modify the path in the FormsConfig website.  We make many connections to SQL with the credentials at the same time using multiple threads.   As for lookup we store the credentials in our tables when you configure the datasource.  We connect to SQL with the supplied account.   Entity Framework manages opening and closing connections.  

0 0
replied on September 14, 2016

Does EntityFramework open a new database connection for each request or is it managing a pool?  If it is a pool, is that pool size configurable and what are the defaults?

 

Is the response in reference to connections to the Laserfiche databases only?  Or does it also apply to other external database connections as well?

0 0
replied on September 15, 2016

SQL connections both to the Forms database and external data sources go through the .NET Framework Data Provider for SQL. Connections are pooled by default, pools are per database and the default maximum size of a pool is 100. See the Microsoft documentation for more info.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...