classtranscribe / classtranscribe/WebAPI

Set Reasonable MaxPool and other DB connection properties

Open
#105 0 comments 0 reactions 2 assignees Claimed by @angrave View on GitHub
Dominant language
C#
Stars
16
Forks
4
PR merge metrics
No merged PRs in 30d

Description

What should DB connection string be for the WebAPI and TaskEngine?

In the database connection string,we hrad code "MaxPoolSize=1000" but this is larger than the number of connections than the database is configured for (500 IIRC).

This setting is currently used in both the API and TaskEngine - it should be possible to split these up.

Any other parameters we should be setting?

On the code side, we will leave the password, username etc as explicit parameters, but support two environment variables,
"TASKENGINE_DB_CONNECTION_EXTRAS" and "WEBSERVER_DB_CONNECTION_EXTRAS"

- but what values should they have?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.