Compile each chart query once per request and cache the drill menu

Each chart query is compiled once per request instead of three times, and the drill menu is cached.