Let me clarify that I think Ilya and I are answering different questions, and not positive which question was being asked :)
For a prolonged process like a large SQL load, mod_perl won't help much; but when the scripts are shorter (and other factors like perl load/compile and database connection & statement handle preparation time are more significant), it can be beneficial. > From: Wilson, Doug > > All - We're putting together a Web-based application using > > Perl CGI, Apache, > > and DBI to connect to a MySQL database (all running on one > > machine under > > Win2k). Off the command line, I can load a source file populate the > > database with ~25000 records in less than 5 seconds, however, > > using CGI and > > the same DBI code takes ~30 seconds. This isn't an online > > system and won't > > receive many hits - only one or two users at a time. > > Native load facilities are usually quicker than the equivalent > DBI code. mod_perl won't help much, if at all. Best solution > might be to have your CGI download the file and use the native > load facility.
