. NET connection string setting connection pool size significantly improves database speed

When accessing the MySQL database, if you set up a connection pool in the connection string and set the connection pool size, you can significantly increase the speed of accessing the database when you test it.

Connection string:

Connectionstrings>
<add name= "ConnectionStr" connectionstring= "Database=userdb;data source=localhost; User Id=root; PASSWORD=ABCABC; charset=utf8;port=3306; pooling=true; Max Pool size=100;" />
</connectionStrings>

The red font needs to be noted: When connecting to a database, the connection pool is used, and the connection pool size is set to 100.

. NET connection string setting connection pool size significantly improves database speed