[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