开发者

reducing timeout exception on MySQL on C#

开发者 https://www.devze.com 2023-01-27 23:45 出处:网络
im trying to control MySQL tables using C#, though it takes my program 5 seconds to load on a 3MBPS internet, and sometimes it throws a timeout exception because my program is taking too long to conne

im trying to control MySQL tables using C#, though it takes my program 5 seconds to load on a 3MBPS internet, and sometimes it throws a timeout exception because my program is taking too long to connect...

follow up question, does the time for the connection to 开发者_Go百科open the only thing that is hard up on loading, or does the queries have an effect?


You have two time out values. Your connection has it's own timeout. This is the period you allow your provider to try and connect to the database.

Secondly you have a Command Timeout, and this is the amount of time you allow your query to execute before a timeout exception is raised.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号