… holds, because that’s the way floats work (surprise!). And the third thing: even though PHP tries to handle this in a crossplatform way (because it uses its own float-to-string and string-to-float utilities… of PHP 5 (released in 2004) type system were either not aware of” long long. As well as designers of MySQL (released…
Comment: PHP vs. BIGINT vs. float conversion caveat
January 11, 2008 By 27 Comments
…MySQL Performance Blog wrote an interesting post today on PHP vs. BIGINT vs. float conversion caveatHere’s a quick excerpt Sometimes you need to work with big numbers in PHP (gulp… not cover 64-bit range fully, floats might save the day. The trick is that PHP floats are in fact doubles, i.e…
Post: Handling big result sets
June 26, 2006 By 13 Comments
…` varchar(39) default NULL, `f11` int(11) default NULL, `f12` float default NULL, `f13` int(11) default NULL, `f14` smallint(6… simple PHP script which retrieves all rows from the table: < ?php $link = mysql_connect(‘localhost’, ‘root’, ”) or die(‘Could not connect: ‘ . mysql_error()); mysql_select…
Comment: Innodb Performance Optimization Basics
April 24, 2008 By 75 Comments
…float(){ list($usec, $sec) = explode(” “, microtime()); return ((float)$usec + (float)$sec); } $time_start = microtime_float(); echo “Start Time for InnoDB: ” . $time_start . “\n”; $db = mysql…
Comment: PHP vs. BIGINT vs. float conversion caveat
January 12, 2008 By 27 Comments
… today on Comment on PHP vs. BIGINT vs. float conversion caveat by Windows…Here’s a quick excerpt[…] MySQL Performance Blog wrote an interesting post today on PHP vs. BIGINT vs. float conversion caveatHere’s a quick…
