reducing timeout exception on MySQL on C#

Question

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 open the only thing that is hard up on loading, or does the queries have an effect?

jvanrhyn · Accepted Answer · 2010-12-01 10:27:33Z

2

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.

answered Dec 1, 2010 at 10:27

jvanrhyn

2,8141 gold badge20 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Gian Santillan Over a year ago

how do i optimize it so that it would not be too laggy when i access my database through C#?

jvanrhyn Over a year ago

This is completely dependent on your Internet connection. You can set the Connection Timeout to the number of seconds you are willing to have your users wait. But no setting is going to make it be less laggy.

Gian Santillan Over a year ago

ouch... my internet connection and my client's is 3MBPS, what timeout should i set it into?

basarat Over a year ago

Timeout specifies the upper limit. So setting it to a high value will not result in a laggy interface. But it can result in a stuck user interface. Its better that your data access be on a seperate thread with an indication on the GUI about the current stage your Data access algorithm is in.

Collectives™ on Stack Overflow

reducing timeout exception on MySQL on C#

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related