Reading data from MYSQL table very Slowly using ODBC connection in C#

Question

0.00/5 (No votes)

See more:

I have fill the data from the MYSQL table using ODBC connection
in query I will be used the joins of the three tables then fill the data & all three combine table rows is 20729378 .
when i will be filled the dataset using dataadapter then it takes lots of time to fill data. near about half hour or not responding some time any method to read the data fast.

Thanks in advance........

Posted 4-Jul-11 0:31am

vrushali katkade

Add a Solution

3 solutions

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)

Wayne Gaylard · Answer 1 · 2011-07-04T00:41:00

My advice with regards to retrieving vast amounts of data from a database, would be to use a DataReader instead of a DataAdapter. This will speed things up considerably. On a second note, you should really be using the ADO.Net connector for MySQL rather than using OBDC. Here MySQL Connector .Net[^] is the download page.

Hope this helps

OriginalGriff · Answer 2 · 2011-07-04T00:48:00

Solution 2

I'm not surprise it takes time: 20,000,000 rows combining in a DataAdapter is very silly. Why retrieve all the rows at once? Why not retrieve them either one at a time, or a page at a time? What are you doing with them that needs all those rows at the same time?

Posted 4-Jul-11 0:48am

OriginalGriff

Mohsan Raza Ali · Answer 3 · 2011-07-04T06:41:00

Solution 3

You need to use transactions. I was having same problem, starting transaction make it 500 time faster.

Posted 4-Jul-11 6:41am

Mohsan Raza Ali