Mark, you should see an increase in speed in both cases, though the multi-user environment would see a more substancial amount of speed increase. One of the reasons would be persistant connections. Though the embeded interpreter would be faster and more efficient in a multi-user environment due to the way it handles each process.
Ilya -----Original Message----- From: Mark Riehl To: '[EMAIL PROTECTED]' Sent: 10/17/01 11:02 AM Subject: mod_perl and DBI 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. Question - If I switch to mod_perl, can I expect to see an increase in speed (specifically in the DBI portion) with only one or two users? Or, will I only see an increase in speed if I had a large number of simultaneous users? Thanks, Mark -- Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]