… PDO but would not expect it to beat MySQLi in speed. It is however bad idea to use mysql_ functions directly… queries if you need. I would also note for many PHP applications abstraction layer is not the main performance problem, also… growth it will however start to crawl. So developing you PHP applications use test database with reasonable amount of data in…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… ~]# for i in 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create… for this server configuration. Going to 10000 tables however insert speed dropped 20 times. This could be because ext3 does not… rows per sec: 3629.3610005806sec. As you can see insert speed starts slower but degrades less, even though drop from 1000…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… needs to be enforced. Serving file by simply reading from PHP or any other heavy programming language and sending it back… makes quite a bit of difference especially on slower connection speeds. Forgetting to set expire Static content rarely changes, in many… as getting it from the server may be close in speed. It also of course depends on the server which you…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… of queries to MySQL parsing may be performance bottleneck, assuming PHP opcode cache is not used. Also different applications may have… box (2Ghz AMD Sempron CPU) using MySQL 4.1 and PHP 5.0. For memcached access memcache extension from pecl was… baselines for comparison. First is speed of PHP Associative array. This is to show kind of peak speed possible at all. Furthermore this…
Comment: Alternatives of PHP ?
September 9, 2006 By 28 Comments
… car. For complex algorithmic tasks like counting words, for example PHP offers native function written in C, called str_word_count… you’d expect from something like GDB, with a few PHP specific features. 3. Unpredictable memory consumption – it’s easy in… the only point that makes sense. If you really want speed and processing efficiency native ASM is the only true way…
Comment: Alternatives of PHP ?
September 10, 2006 By 28 Comments
… piece of flame. I\’m still using PHP for next bunch of XMLs. 1) Speed. I\’m speaking not only about C… under active development. Did you use it for debugging cli php scripts? 3) memory: I\’ve posted bug report about memory consumption in libxml: http://bugs.php.net/bug.php?id=38604. Also I\’ve seen such problem several…
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
Speed of InnoDB recovery is known and quite annoying problem. It was discussed many times, see: http://bugs.mysql.com/bug.php… in http://bazaar.launchpad.net/~percona-dev/percona-xtradb/recovery-speed-hack/ tree. The patch by itself is quite small, I… it: http://bazaar.launchpad.net/~percona-dev/percona-xtradb/recovery-speed-hack/revision/86 So your comments about patch is welcome…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… lot of time optimizing PHP code but because it takes only 10% of response time in average even speeding it up 10…. At the same time if we find a way to speed up Sphinx we can reduce response time to its half… is not the biggest part yet but if we’d speed up Sphinx and MySQL dramatically we would have to go…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… PDO but would not > expect it to beat MySQLi in speed. It is however bad idea to use > mysql_ functions directly…’s not as common. > I would also note for many PHP applications abstraction layer is > not the main performance problem, also… growth it will however start > to crawl. > So developing you PHP applications use test database with reasonable > amount of data in…
Comment: Intel 320 SSD read performance
September 27, 2011 By 10 Comments
Unfortunately the high cost of SSD doesn’t take advantage of the covenant in speed. Interesting comparison, the speed and volume of record described http://www.xtremesystems.org/forums/showthread.php?271063-SSD-Write-Endurance-25nm-Vs-34nm
