I have a smallish site that is taking a knock from the traffic as it's dynamically-driven. Does anyone know of a CMS that generates static directory structures and HTML files as output? The DB that it uses can be anything really, however if it supports sqlite that'd be awesome.
you want a flat file cms. Your assertion that you are losing traffic because your site is dynamic is unfounded unless your host can not serve pages fast enough to keep up with demand.
You're assuming that I don't know what I'm doing. I've already investigated the problem, and the tl;dr version is simply that switching to static pages would be the best solution for the time being.
Wordpress plus super cache will serve cahced html pages, jsut throwing it out there. A true html CMS would be nice for hackibility, I'll have to keep an eye out for one.