…to convert different types of data from binary strings to PHP variables. What if you try to unpack unsigned 32-bit big… would be converted to float, or string, or something, but …To summarize, if you need to unpack an unsigned 32bit int from binary stream, you have to: convert it to float or string…
Post: Handling big result sets
June 26, 2006 By 13 Comments
… used server needs to convert millions of values from int to the string and client has to do reverse conversion. This takes time. Furthemore string data takes…, probably because of binary protocol and so no data conversion to string as with standard protocol
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… in my opinion without a big need. I told them …about 50% slower compared to Joining on Int, for MyISAM however …to do is to convert Innodb table to latin1 character set. I was expected this to shorten some internal buffers MySQL has to… Finally I decided to check if using longer strings slows down …
Post: PHP vs. BIGINT vs. float conversion caveat
January 10, 2008 By 27 Comments
… need to work with big numbers in PHP (gulp). For example, sometimes 32-bit identifiers are not enough and you have to use… you should be aware of. On different systems, float is converted to string differently. (I spent a bit of time fighting with it…-bit systems where 32-bit int overflow will implicitly convert to float) and getting strange bugs, remember that string conversion might let you down…
Post: INSERT ON DUPLICATE KEY UPDATE and summary counters.
May 29, 2006 By 48 Comments
… of it. Myself I like this feature big deal because it is designed in truly MySQL … example: create table ipstat(ip int unsigned not null primary key, hits int unsigned not null, last_hit…inet_ntoa functions which can convert IP address strings to integers and back. This allows to save on field …
