Internet usage getting high after connecting to MySQL database on net

Question

0.00/5 (No votes)

See more:

I have one windows application which keep connecting to mySQL database which is on db4Free. I found that my data usage is really high whenever i connected to that database. Data usage I found is 300 MB per 20 Minutes.. I even not used any image upload. I am just reading data from that mySQL database table. and reading of data is frequent like per second. I am just using simple queries.

I am not at all blaming to db4free website for this, this is my coding fault or weak knowledge.
Please help me.

I have tagged this question with MySQL-Connector Because codeproject throwing error while selecting MySQL tag.

Posted 20-Sep-14 22:01pm

nilesh sawardekar

Updated 20-Sep-14 22:08pm

Kornfeld Eliyahu Peter

v5

Add a Solution

Comments

nilesh sawardekar 21-Sep-14 4:26am

Thanks for editing.. but can you answer me too..

2 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)

George Jonsson · Answer 1 · 2014-09-21T00:19:00

This is not a direct solution to your problem, but might help you to find out what is happening.

You could use a tool to analyze the traffic on your computer in order to see what is going on.
Sysinternals is a good place to start for different windows tools.
Sysinternals Networking Utilities[^]
Look for TCPView. It will show you which connections you have open, but doesn't contain a monitor.

Quote:

TCPView is a Windows program that will show you detailed listings of all TCP and UDP endpoints on your system, including the local and remote addresses and state of TCP connections.

For a network monitor you can try this tool from Microsoft
Microsoft Network Monitor 3.4[^]

Quote:
Tool to allow capturing and protocol analysis of network traffic.

If it is an application you have the source code for, you can always add a logging functionality that writes sent and received data to a file.
If you create a new file every 5 or 10 minutes, you can see how much data that is transferred within this time frame.

Mehdi Gholam · Answer 2 · 2014-09-20T22:27:00

Solution 1

Data transfer and "querying" imply the use of bandwidth and depend on how many rows are being requested per query.

Doing the math : 300,000 Kb / 20*60 seconds = 250kb/sec which is reasonable.

Try enabling compression.

Posted 20-Sep-14 22:27pm

Mehdi Gholam

Comments

nilesh sawardekar 21-Sep-14 4:50am

Thank you for your reply.
Just want to confirm that what will be solution if I only looking for 2 or 3 rows per second.
and also,
can you give little advice on enabling compression.

Mehdi Gholam 21-Sep-14 5:04am

For 2-3 rows 250kb is a lot for plain SQL, using compression depends on how you are connecting to the database service.