I often monitor MySQL queries for some complex application components that use an ORM (Doctrine). I’ve just made a special logger that re-runs all the quries with an EXPLAIN and log the “Extra” column of the explain query, in order to spot queries that can be improved. From the log, I pipe the result to [...]
|
||||||
|
MySQL optimizer rewrites uncorrelated subqueries (when the inner query does NOT use fields of the outer query) as correlated query, with perrformances of quadratic order rather than linear. If the inner query does not use a WHERE with fields on the outer query, rewrite it as a JOIN Source: MySQL :: MySQL 5.5 Reference Manual :: [...] Markdown – Wikipedia, the free encyclopedia Markdown is a lightweight markup language, originally created by John Gruber and Aaron Swartz allowing people “to write using an easy-to-read, easy-to-write plain text format, then convert it to structurally valid XHTML (or HTML)”.[1] The language takes many cues from existing conventions for marking up plain text in email. [...] Usage Statistics and Market Share of PHP for Websites, January 2012 This report shows the usage statistics and market share data of PHP on the web
If the autoloader is enabled: $mock = $this->getMockBuilder(‘MyNamespace\sub\ClassToMock’) [...] In this post I’ll just write some notes to install the ZFDebug panel for Zend Framework. That’s basically a front controller plugin that displays at the bottom of the layout (slides from the bottom), contains “debug panels” (cache, variables, zend db, time info etc…) and it’s easy to extend. Copy libraries and images Grab the [...] Profile your PHP application and make it fly Profile your PHP application and make it fly View more presentations from Lorenzo Alberton. [...] As PHP is becoming a widely used web server technology, more and more developers are comparing PHP with other technologies like J2EE or .NET.It has been the butt of criticism as considered not scalable: totally wrong ! A system is scalable when is able to keep the performances under an increased load, mainly due to [...] There are lots of advices on the web about how to speed up PHP applications.The best reading I’ve found are written by Ilia Alshanetsky [blog]: PHP & PERFORMANCE [pdf]By: Ilia Alshanetsky Common Optimization Mistakes [pdf]PHP Quebec 2009 Enjoy ! When the aim is to check if the element exists in an array and has a value not null, better to use isset(array[index]), that is much faster than array_key_exists(index, array). #PHP 5.3.0 command line – Amd turion 64 1.6 Ghz #create array$a = array();for($i = 0; [...] |
||||||
|
Copyright © 2012 PHP and tips - All Rights Reserved |
||||||