questions on serving big file & SQL statement parsing

["James. L" <suppressed>]

Hi, all

I got curious when reading 'performance tuning' in
mod_perl doc.

two questions.

1. "SQL statement parsing" is mentioned in the doc:
http://perl.apache.org/docs/1.0/guide/performance.html#toc_Eliminating_SQL_Statement_Parsing

i am curious that if it is a general practice(caching
sql statement in package variable to avoid parsing) to
do the My::DB thing in mod_perl app ?

2. "Upload and Download of Big Files" 
http://perl.apache.org/docs/1.0/guide/performance.html#toc_Upload_and_Download_of_Big_Files

it mentions that serving static file from the
front-end server but also mentions the following:

"This of course assumes that the script requires none
of the functionality of the mod_perl server, such as
custom authentication handlers."

I am wondering how do you do it if i have to auth user
first?

thanks,

James.


       
____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.
http://smallbusiness.yahoo.com/webhosting