…6.4 Single core VM 528M RAM Host-Only network 1 Box with http/php, 1 box with memcache or mysql started PHP… benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600, ‘…2.33863 ms per/cmd 1.449 ms min per/cmd 7.324 ms max per/cmd 5…
Post: PHP vs. BIGINT vs. float conversion caveat
January 10, 2008 By 27 Comments
… with PHP 5.1.6 or 5.2.2, and also with PHP 4.4.2 on SPARC64 under NetBSD 3.0: s1=1125899906842625 s2=1125899906842625 However 32-bit FreeBSD with PHP 4.4.7 produces different results: s1=1.1258999068426E+15 s2=1125899906842625 The same 32-bit FreeBSD box with PHP 5.2.5 starts to… it comes to fixing PHP “subtleties” in numeric value handling: it can be used to workaround signed vs. unsigned int issues; it…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…6 tables, what version of Innodb/MySQL would you recommend? I’ve been staying at 4.1…5.1.X will be better, but still not sure. HT: 5.0.xx, where xx >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5.0 vs 4.1…com/bug.php?id=…(from 16GB, 2 two-…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…vs…6.0645327150223 | 0.11126040714778 | 0.17609498370795 | 0.54612972549309 | 0.16651488365119 | +———-+—————–+——————+——————+——————+——————+ 1 row in set (2…PHP…5 minutes or even 1…| 2.9788750504185 | 0.53700871350403 | | 15 | 4081 | 4….
