News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Eran Galperin's Blog:
Profiling queries with Zend_Db and optimizing them by hand
October 13, 2008 @ 10:29:20

Eran Galperin has a new post today that talks about profiling your database queries for optimum efficiency with the help of a component from the Zend Framework, the Zend_Db_Profiler.

Database performance is one of the major bottlenecks for most web applications. Most web developers are not database experts (and I'm no exception), there are however several basic methods to analyze and optimize database performance without resorting to expert consultants. [...] Since I'm dealing mostly (only?) with MySQL, this article covers it mainly (though it is probably relevant to a large degree for other engines).

Eran talks about first profiling your application and checking to see where the real problems might be. Something as simple as microtime can be used to check out the script execution time. For something a bit more powerful, though, the Zend_Db_Profiler component is suggested. It makes it possible to run sample queries from your data and get back the relevant query's runtime (with no page manipulation involved).

0 comments voice your opinion now!
profile query optimize mysql zenddbprofiler zendframework component tutorial


blog comments powered by Disqus

Similar Posts

PHPMaster.com: Internationalization Made Easy

Community News: Zend Framework 1.0.0 Released

Matthew Weir O'Phinney's Blog: Zend_Layout and Zend_View Enhanced components now in core

Ian Selby's Blog: Making RESTful Requests in PHP

Jani Hartikainen's Blog: Zend_Acl part 2: different roles and resources, more on access


Community Events





Don't see your event here?
Let us know!


series language opinion interview community api list tips laravel release podcast package symfony deployment introduction install voicesoftheelephpant framework library bugfix

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework