October 2009
Beginner
408 pages
7h 27m
English
As your PHP applications become more complicated, your app's performance will start to play a key role in development. MySQL is a potential performance killer in applications, creating bottlenecks that prevent scripts from executing as quickly as you want them to.
Part of your role as a developer is to know the risks involved with MySQL queries and eliminate as many performance issues as possible. The most common risks I'll show you how to address in this chapter include:
Poor planning of database tables
Requests for unnecessary data (using the shortcut selector [*])
NOTE
Database architecture and optimization is a huge task; it's actually a career in and of itself. This book covers only the ...
Read now
Unlock full access