Hacker News new | ask | show | jobs
by mutagen 4086 days ago
200+ queries for a simple dynamic page doesn't surprise me. Once you add some dynamic features it's easy to start sticking all kinds of stuff in the database. Let me check some sites I run:

  Medium complexity Drupal 6 site: 200-300 queries
  Wordpress site with accretion of plugins over the years: 100+ queries
  Drupal 7 site: 100+ queries
Those totals might be inflated due to having administrative menus active.

Many of these are key/value lookups which can be accelerated by serving from Memcached or Redis, although I imagine SQLite dishes them out pretty quickly as well.