Please check the image above from running nopcommerce in one of the categories. See how many connections it opens and closes for each query? Why can't NopCommerce reuse connections?
I have set Pooling to be true in my connection string in dataSettings.json file.
This is my dataSettings.json file content:
{
"DataProvider": "sqlserver",
"DataConnectionString": "Data Source=xx;Initial Catalog=xx;Encrypt=True;TrustServerCertificate=True;Connection Timeout=300;Min Pool Size=100;Max Pool Size=2024;Pooling=true;Integrated Security=False;Persist Security Info=False;User ID=xx;Password=xx",
"RawDataSettings": {}
}