Mysql exception timeout

Question

1.00/5 (1 vote)

See more:

I have several tabs that load some data on datagrid, the 1st tab works fine, but the 6 others cause my program to freeze. How can i fix it?
This is the code i have for tabcontrol_selectedindexchanged propriety

Code:

[C#] Code - Pastebin.com[^]

What I have tried:

Tried to restructure all the code, from ground 0 with no success...

Posted 1-Mar-16 6:00am

Scribling Doodle

Updated 1-Mar-16 17:26pm

Add a Solution

Comments

ZurdoDev 1-Mar-16 12:15pm

If you are timing out make sure you aren't locking the tables. And find a way to create indexes or something to make it faster.

Scribling Doodle 1-Mar-16 12:26pm

What do you mean by "locking the tables"?

ZurdoDev 1-Mar-16 12:49pm

I don't know MySql well enough to tell you specifics but when you select data, a lock is put on the data. Sometimes it's just a row lock or it could be a table lock. I suggest reading up on it.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Matt Comb · Accepted Answer · 2016-03-01T17:26:00

Solution 1

Scribling doodle is right in the sense that, it is most important that you prevent the timeout rather than working out how to absorb it.

Having said that, if you are unable to prevent the timeouts from occurring, you should attempt to do the following:

1. Put the code that fetches the data into a thread, so if it times out, it will timeout the thread not your main form, this will make sure that your application remains responsive.
2. Handle exceptions. If you're getting a timeout exception, handle it, e.g. give the opportunity for the user to retry or cancel.

Posted 1-Mar-16 17:26pm

Matt Comb

Comments

Scribling Doodle 2-Mar-16 3:38am

i keep gettng timeout exceptions because my main tables have 250k+ rows, which can cause some troubles. I'll give a try about threads

[no name] 2-Mar-16 3:53am

Why are you fetching 250k records, is this really need of that. Secondly you can use indexing on the columns which you are using fro filtering purpose.

Scribling Doodle 2-Mar-16 4:04am

im creating a parking lot system that requires much data, to know who entered and who left, per day my parking lot has arround 10k+ users joining and leaving. this is the data from the 1st day i began this project, since 2011 or so.

I want my employees to be able to track every car that was here and still is, thats why requesting 250k+ values.