Guidelines for writing efficient SQL code
Last modified: August 26, 2009 - 21:12
These quidelines provide some tips for writing efficient SQL code.
Guidelines apply to MySQL and PostgreSQL.
Developing for Drupal
- Setting up a development environment
- Flash And Drupal Technique
- Module developer's guide
- Working with the Drupal API
- Drupal Programming from an Object-Orien
ted Perspective - JavaScript in Drupal
- SimpleTest
- Standards, security and best practices
- Drupal UI guidelines
- Developing installation profiles
- Guidelines for writing efficient SQL code
- Install tools to measure performance of SQL queries
- Never trust Drupal SQL query execution time
- Run EXPLAIN on slow queries to fin sequential scans
- Nerver trust EXPLAIN unless you run a large Drupal site
- Indexes are not symmetric
- Make sure that JOIN columns both carry indexes of the same type
- Conclusion and summary of the guidelines
- Contributed modules for developers
- Guidelines for writing MySQL and PostgreSQL compliant SQL
Quick links
Handbook license
The Drupal handbook pages are © 2000-2009 by the individual contributors
User login
Contributor links
- Community initiatives
- Queues
- Play patch bingo!
- Play bug bingo!
- Mailing list archives
- Drupal.org webmasters
- Drupal.org server administrato
rs - Drupal.org CVS applications
- Web links