Joel, > The two worst queries (our case and audit applications) I created > denormalized files and maintain them through code. All reporting comes off > those and it is lightning fast.
Advertising
This can often be called for. I'm working on a 400GB data warehouse right now, and almost *all* of our queries run from materialized aggregate tables. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
