I think that perlmonks.org is running in perl CGI + mysql, why can't it use mod_perl + mysql? please tell me the pros and cons of this issue.
UPDATE
Pardon my ignorance, I was wrong to tell that perlmonks is running using perl CGI and mysql.
but I am enlightened by perrin and corion(via chatterbox) that perlmonks is already using mod_perl + mysql

Vivek
-- In accordance with the prarabdha of each, the One whose function it is to ordain makes each to act. What will not happen will never happen, whatever effort one may put forth. And what will happen will not fail to happen, however much one may seek to prevent it. This is certain. The part of wisdom therefore is to stay quiet.

Replies are listed 'Best First'.
Re: cgi or mod_perl
by CountZero (Bishop) on Feb 16, 2009 at 19:31 UTC
    The main advantage of mod_perl over CGI is that mod_perl keeps your scripts compiled "in memory" so every next invocation of the same script does not suffer the usual start-up cost of starting a Perl-interpreter and loading and compiling the script.

    The main disadvantage is that you must write these scripts very carefully. The persistence of your scripts could easily cause strange errors, such as variables retaining a previous value or unexpected closures happening over your subroutines.

    An additional property of mod_perl is that this module opens the whole of the Apache server to you. Whether this is an advantage or a disadvantage depends on your point of view. System administrators or companies renting servers look at such power with dread and suspicion, hence your "run of the mill" webspace provider is more likely to point you towards PHP than towards mod_perl.

    CountZero

    A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

Re: cgi or mod_perl
by Joost (Canon) on Feb 16, 2009 at 17:07 UTC
Re: cgi or mod_perl (mod_perl)
by tye (Sage) on Feb 16, 2009 at 17:06 UTC

    This site is using mod_perl. I'm sorry, I won't try to produce a list of pros and cons. Perhaps if you ask a less expansive question or a more to-the-point question, you would be more likely to get a response.

    - tye        

Re: cgi or mod_perl
by wazoox (Prior) on Feb 16, 2009 at 20:16 UTC
    Some would say that Perlmonks should run on mod_perlite :)

      This monk would say FastCGI :-)

      meh.