[Cialug] mysql database design
Nathan C. Smith
nathan.smith at ipmvs.com
Thu Aug 9 13:46:50 CDT 2007
Does MySQL have triggers now?
> If I want my reports to be snappy, I sometimes set up a dedicated task
> that runs as a low priority and denormalizes my data into "report
> friendly" format using a single or maybe two tables. Then I run my
> task at 15 min intervals. That way, when PHBs run their report, they
> get it in 2.3 seconds which makes them happy and makes me look like a
> god, since everyone else's reports take 90s or more. :-)
> --
> Matthew Nuzum
> newz2000 on freenode
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>
More information about the Cialug
mailing list