reducing timeout exception on MySQL on C#

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.