I'll like to know what are the things to consider when choosing between configuring an app as static or as dynamic in an Apache 2 server that uses mod_fastcgi. The app is a typical reporting app written in Perl with MySQL as the Db backend with fairly medium traffic. I'll love to hear your experiences about running FastCGI in such a scenario.
Neither of them really has set performance or scalability characteristics divorced from the context of your app and its environment. Which would work better depends on what you have going on.
Static: set number of app processes that hang around all the time. Conditions that argue for this include:
Dynamic: variable number of app processes that are started on demand and killed off when unused. Conditions that argue for this include: