Chapter 4: Simple Recipes
The tips provided in this chapter will require a little more effort, but the performance results on new and existing sites may be more dramatic. Some of the simplest but most effective database optimizations are tackled first before delving into images, media, fonts, CSS animations, and some controversial topics.
Optimize Your Database
Database access is often the biggest processing bottleneck on the server. Optimizing front-end performance may be futile if your database is struggling to cope with user demand.
There are a vast array of database types, but common performance solutions are described in the following sections.
Use a Query Analyzer
Most databases provide tools that describe how a query has been processed. ...
Get Jump Start Web Performance 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.
