PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide

Improving Web Application Performance

As a conclusion to this chapter, I want to mention several performance-related techniques to be used with Web applications. The busier a site is, the more important each little tweak will become.

The performance of your Web applications is dictated by many things, generally

• The physical server itself

• The PHP scripts

• MySQL and SQL

Tips

• The most obvious and expensive way to improve the performance of your Web applications is to upgrade the server itself: processor speed, memory, hard drives (type, speed, size, etc.), connection to the Internet, and so forth.

• Another way to improve the speed of your Web applications is to tune how MySQL runs. You can do this by specifying different options, such as the key_buffer ...