Changing ASP <connectionStrings> parameters in web.config needs a recompile?

0
votes


Since my site goes very slow, I googled and I found that the problem could be in the connection pool.
So I would change my connection string from:

< add name="ConnectionString" connectionString="Database=aaa;Data Source=bbb;User Id=ccc;Password=ddd;" providerName="MySql.Data.MySqlClient"/>

to

< add name="ConnectionString" connectionString="Database=aaa;Data Source=bbb;User Id=ccc;Password=ddd;" providerName="MySql.Data.MySqlClient" Max Pool Size=100; Min Pool Size=10 />

Since actually I don't have defined any max and/or min pool size, I thought that, maybe, adding this 2 properties, the site will be more fast.

If I'll modify this row, I need to restart the server and/or recompile the ASP project to take this changes?
Finally, what is the maximum number allowed to Max Pool Size?

Thanks a lot.

1
asp.net.netwindowsweb-configconnection-pooling
I highly doubt making these changes will speed your site up. If anything, it will probably slow it down. Rather than guessing indiscriminately at what might be slow, take the time to actually profile your site and see what's slow. Use a tool like MiniProfiler or simply add some logging around your processes that are running slow to isolate where the slow behavior is occurring. - mason
Thanks for your support @mason, but do you know if I need to restart the server or recompile all to make changes updated? Thanks! - Francesco L.
If you change the web.config file, the site will automatically restart. You do not need to do anything beyond modifying the file. Although as I pointed out, you're probably barking up the wrong tree anyways. - mason

1 Answers

0
votes

If you are changing anything in web.config, your site will automatically restart and if you already logged in the application it will asks to relogin.

Also This doesn't going to help to improve the slowness of the application. I think you should found the actual reason behind the slowness. definitely it would be something else. This might help you.