> 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. HTH, Douglas Wilson