News Feed
Sections




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

Mike Willbanks' Blog:
PHP Performance Series Maximizing Your MySQL Database
June 19, 2008 @ 12:01:24

Mike Willbanks has posted another part in his "PHP performance" series today. In his previous article, he talked about caching techniques including things like opcode caching and database memory tables. This time he talks about getting the most out of your MySQL database.

Application level SQL performance is much different than the performance of the SQL query itself but rather how it has been designed to work in the application. Many of the items I will be addressing in this area is designing your application to make less queries thus improving scalability and likely performance. However, performance does not always equal scalability as the same with scalability does not always equal performance.

He looks at a few different topics like lazy connections, iterating queries, need-based selects, normalization and a few simple things that you can apply to every SQL your application uses to optimize it as much as possible.

0 comments voice your opinion now!
performance series maximize mysql database tip sql query


blog comments powered by Disqus

Similar Posts

Stephen Colebourne's Blog: Time-zone database down

Joakim Nygard's Blog: Timezones in MySQL and PHP

SitePoint PHP Blog: Building a Web App with Symfony 2: Finalizing

Andrew Podner: Functional Testing to Improve Quality Assurance (part 2)

Matthew Weier O'Phinney: RESTful APIs with ZF2, Part 3


Community Events





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


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

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