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:
Database Optimization Techniques You Can Actually Use
March 28, 2011 @ 13:15:57

Eran Galperin has posted a few helpful tips (ones you can "actually use") for optimizing your database and how your application uses it.

I understand the need for simplicity because of the wide audience of Smashing Magazine, but I'd wish they'd give something more than the absolute basics you could find in almost any other site out there [in their recent tutorial]. I also didn't like some of the methods mentioned there for profiling (or the code itself), so I here is my starter guide to optimizing database performance.

Tips included in his post center around a different set of questions:

  • When should you optimize the database?
  • Think about profiling first, optimizing last
  • How EXPLAIN can find the big problems
  • When caching should be used

Some code is included, but only briefly since his point is more about the server than the client (script) side of things.

0 comments voice your opinion now!
database optimize technique explain cache profile


blog comments powered by Disqus

Similar Posts

Alvaro Videla's Blog: A Word About Caching: Memcached and APC

Ralph Schindler's Blog: Composite Rowsets For Many-To-Many Relationships Via Zend_Db_Table

Johannes Schluter's Blog: Escaping from the statement mess

Melvin Rivera's Blog: Creating a custom WordPress database error page

IBM developerWorks: Kick-start takes you to the movies (Part 1)


Community Events





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


list community developer opinion experience configure language podcast threedevsandamaybe introduction testing install code laravel unittest series framework interview symfony2 release

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