Jump to content

Amount of bandwidth required to send a query to mysql server?


Unity+

Recommended Posts

How many bytes are required to send a query to a mysql server over the web? I know it is relative to the data being sent, but let's just say we are only sending 4 integers and 1 date/time type. What is the required bandwidth to do this?

 

EDIT: Let's also assume that an ODBC is being used to make this connection.

Edited by Unity+
Link to comment
Share on other sites

How many bytes are required to send a query to a mysql server over the web? I know it is relative to the data being sent, but let's just say we are only sending 4 integers and 1 date/time type. What is the required bandwidth to do this?

 

EDIT: Let's also assume that an ODBC is being used to make this connection.

I am a unsure what you are asking. Four integers and a date/time are not precise types. How many characters in each integer, 1 or 1,000,000. To what precision are you specifying time, 1 hour or 0.000,000,1 second. Bandwidth can be specified a few ways, for example baud, bits per second, or Hertz respectively for a twisted pair telephone line, fiber optic cable, or radio. Moreover, any amount of data (4 integers and a date/time) can be sent either fast (high bandwidth) or slow (low bandwidth), depending on the equipment being used. For example, a message over a telephone line might be sent at 9600 baud (about 1200 characters per second); whereas, over a fiber optic cable might be 1 Tbits/s per second (about 125 billion characters per second).

 

ODBC messages have required overhead characters, in addition to your data, which affect overall message length, but don't affect the speed messages are sent. Although, more characters to send increase the time it takes to transmit a message at a given bandwidth.

 

Perhaps you can refine your question, if my broadside hasn't answered it.

Edited by EdEarl
Link to comment
Share on other sites

How many bytes are required to send a query to a mysql server over the web?

 

Get personal firewall such as Sygate Personal Firewall, or other tool allowing to see packets send by your machine,

write code connecting to MySQL server and sending data, or use MySQL admin,

and see packets and count their sizes..

 

ps. Sending this reply was 1514 bytes in packet log viewer.

Edited by Sensei
Link to comment
Share on other sites

 

 

Get personal firewall such as Sygate Personal Firewall, or other tool allowing to see packets send by your machine,

write code connecting to MySQL server and sending data, or use MySQL admin,

and see packets and count their sizes..

 

ps. Sending this reply was 1514 bytes in packet log viewer.

 

That's a good idea, and might be what Unity wants; of course, message length and bandwidth are not the same.

 

There are sites that measure your actual bandwidth, for example:

http://speedtest.texas.rr.com/

http://www.speedtest.net/

Edited by EdEarl
Link to comment
Share on other sites

That's a good idea, and might be what Unity wants; of course, message length and bandwidth are not the same.

 

There are sites that measure your actual bandwidth, for example:

http://speedtest.texas.rr.com/

http://www.speedtest.net/

Sorry for the long wait.

 

Yeah, I meant length. I used wireshark to detect this, and it turns out it takes 1742 Bytes for MS Access to send a request(at least with my query).

 

Thanks for the help.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.