News Feed
Sections




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

Brandon Savage's Blog:
Hitting the Database Less Quick and Dirty Strategies for Database Efficiency
November 17, 2008 @ 11:04:24

In this new post to his blog, Brandon Savage looks at a few methods you can use to help reduce the overhead connecting to the database can cause.

Below are a list of my top five quick-and-dirty strategies for improving database performance in web applications. These suggestions are culled from recent experience and mixed with some ideas that I've implemented in my own code. They're not high level, but they are something we need consistent reminders about.

Here's the short version of the list:

  • Try caching
  • Reduce the number of queries that run
  • Use indexes
  • Optimize data usage
  • Avoid functions in WHERE statements

You'll have to check out his post for the full versions, though.

0 comments voice your opinion now!
strategy database efficiency tip list cache index optimize where


blog comments powered by Disqus

Similar Posts

Zend Developer Zone: Build an Enterprise-Grade PHP Stack with Zend Server 5.0 and Oracle 11g

Vexxhost.com: Top 5 new (and cool!) features in PHP5 that you probably haven't heard of

DevShed: Updating and Deleting Database Records with the Active Record Pattern

Stuart Herbert's Blog: Quick Tip: Get, Set and Query in One Method

DevShed: Working with MySQL and Sessions to Serialize Objects in PHP (Part 3)


Community Events





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


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

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