Note: This article assumes single server deployment and therefore doesn't cover topics such as load balancing
Code Profiling
Use xdebug's profiling option. This will give you insight into areas of your code that may need optimization.
SQL Profiling
Most of my projects use PostgreSQL, so I haven't actually used this myself, but here's some documentation on profiling your MySQL queries. Again, it'll give you insight into areas of your SQL scripts that could use some optimization.
Investigate Cache Options
If you have a lot of database queries on your pages or a lot of PHP logic in your pages, it can be expensive to generate. There are a few different methods of cacheing and, while each method helps to solve load times, each aims to solve different specialized problems:
- File based cache (article that explains the concept fairly well)
- APC cache
- Memcached
- MySQL query cache
No comments:
Post a Comment