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

[Unity+]

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 May 17, 2015 by Unity+

[EdEarl]

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 May 17, 2015 by EdEarl

[Sensei]

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 May 17, 2015 by Sensei

[EdEarl]

 

 

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 May 17, 2015 by EdEarl

[Unity+]

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.