Saturday, May 25, 2013
Web Application Performance Tuning
von Sascha Kersken (papaya Software GmbH)
Saturday, 25.05.2013, New York II, 14:45-15:30 Uhr
There are several areas in which web applications can be made faster, starting with the database and code optimizations over different techniques of caching up to client-side performance enhancement. This talk addresses some of them, using papaya CMS and its application framework as an example - but the lessons learned can be applied to almost any CMS, framework, programming language, and database.
1. SQL Query optimization - Identifying slow queries - Identifying abundant queries - Using indexes to enhance query performance - Refactoring queries to increase their performance
2. Server-side code level optimization - Identifying performance traps in your code - Refactoring code to avoid them
3. Caching - Overview: the various levels of caching - Content caching - Byte code and template caching - Output caching - Setting HTTP headers for browser and proxy caching - Using dedicated web caches (Varnish or Squid)
4. Client-side optimizations - Otimizing HTML and CSS structures - Finding the correct locations for styles and scripts - Using output compression - Using CDN
Über den Autor Sascha Kersken:
Sascha Kersken has been using computers since 1983 and some day turned this long-year hobby into his profession. He works as a senior developer for papaya Software GmbH in Cologne, Germany. The company's main product is the open source PHP-based web content management system papaya CMS. Besides, Sascha has been working as a trainer and consultant, both as a freelancer and employed. He regularly presents speeches and tutorials at software conferences throughout Europe, and is the author of several textbooks and articles. His main fields of interest include, but are not limited to, the web and Linux/UNIX.