3.6.07. Query caching

  • Complex - Summary table
    • Multiple queries drawing data from subset of DB data
    • Cache subset
      • Query subset rather than whole database
  • Complex - Age analyses
    • Webstats, meaningful even if not last 24 hours
      • Run the heavyweight analysis queries during downtime
      • Cache results