I may just be thinking about things wrong but, maybe someone can help me with this. I have a client who has a website where they list upcoming events in the area and whenever they start getting a lot of traffic, it throws a bunch of MySQL errors because it wasn't built well and it pounds the database. They are only updating the listings about once a day and doing it through a crappy, custom-built CMS.

My thinking is that I could use cron or a button in the CMS to call a static site generator like Phrozn, which would query the database once and create the main page of the site but, I haven't been able to find any info on doing something like that; it seems like most static site generators are meant to read text files.

So, I guess my question is: is there a way to do what I've described or am I approaching it from the wrong angle? I'll most likely be re-writing the site regardless, I'm just looking for the most efficient way to do so.