Right, Doug. I was not clear on the question myself. Later after rereading I realized the batch load part of it. You are correct that the native loading facilities are much faster than DBI.
Though my answer was directed towards the "This isn't online system... and the mod_perl vs. standard Perl interpreter" part of the question:-) Ilya -----Original Message----- From: Wilson, Doug To: 'Mark Riehl'; '[EMAIL PROTECTED]' Sent: 10/17/01 11:24 AM Subject: RE: mod_perl and DBI 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.
