Server to Clienst: Transmitting just ASCII for numericals?
Posted by: Jens Ruena
Date: December 07, 2012 05:05AM


While investigating performance problems in our legacy multi-client application, I found that our clients read all values (ints, doubles, etc.) from the MYSQL C-Connector in ASCII literals. That means all numbers are coded in text (the String “123” for the int 123). Most of our data consist of numerical values (ints and doubles). Our main performance problem are queries that take to long, so I am wondering:
* Does MySQL transmit numerics as ASCII? So the server has to do the sprintf(), and the client has to do the sscanf()?
* Is there a way to get binaries form the MySQL server? (we are using mysql_fetch_row())
* Is MySQL itself just storing text? (I don't think so)
* Is the transmission of ASCII data not considered a common bottleneck?

Thanks a lot

Options: ReplyQuote

Written By
Server to Clienst: Transmitting just ASCII for numericals?
December 07, 2012 05:05AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.