4.4. Table Structure and a Crash Course in Planning
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 ...
Get PHP for Absolute Beginners now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
