Re: questions on serving big file & SQL statement parsing

2007-07-03 Thread Jonathan Vanasco
On Jul 3, 2007, at 4:02 AM, Clinton Gormley wrote: This last statement I have a quibble about : using mod_perl to handle file uploads. I may be wrong here, so I'd welcome reasoned disagreement, but the way I understand it: not all file uploads, but large ones. anything over 100k i won't

Re: questions on serving big file & SQL statement parsing

2007-07-03 Thread Perrin Harkins
On 7/3/07, Clinton Gormley <[EMAIL PROTECTED]> wrote: > It's not a very important distinction, but perl code is not compiled > into C. It gets compiled to an intermediary format of Perl opcodes, > which you can see with the B:: tools. Apparently, those opcodes are C-structs, rather than an inte

Re: questions on serving big file & SQL statement parsing

2007-07-03 Thread Clinton Gormley
On Tue, 2007-07-03 at 10:37 -0400, Perrin Harkins wrote: > On 7/3/07, Clinton Gormley <[EMAIL PROTECTED]> wrote: > > However, the Perl code itself has > > already been compiled into C and is fast. > > It's not a very important distinction, but perl code is not compiled > into C. It gets compiled

Re: questions on serving big file & SQL statement parsing

2007-07-03 Thread Perrin Harkins
On 7/3/07, Clinton Gormley <[EMAIL PROTECTED]> wrote: However, the Perl code itself has already been compiled into C and is fast. It's not a very important distinction, but perl code is not compiled into C. It gets compiled to an intermediary format of Perl opcodes, which you can see with the

Re: questions on serving big file & SQL statement parsing

2007-07-03 Thread Perrin Harkins
On 7/2/07, Charlie Garrison <[EMAIL PROTECTED]> wrote: mod_auth_tkt That's what I use for this. - Perrin

Re: questions on serving big file & SQL statement parsing

2007-07-03 Thread Clinton Gormley
> > in my case, i need to do authorization. do i need > > extra mod_perl front-end server to do this? how does > > this perform? the beauty of mod_perl is that you can step in and out of the process wherever you need to. The down side is that mod_perl uses a lot of memory, so you try to keep your

Re: questions on serving big file & SQL statement parsing

2007-07-02 Thread Jonathan Vanasco
On Jul 3, 2007, at 12:21 AM, James. L wrote: i probably should give more detail about my question. in my case, i need to do authorization. do i need extra mod_perl front-end server to do this? how does this perform? also, will serving the file from backend mod_perl server to the front-end pro

Re: questions on serving big file & SQL statement parsing

2007-07-02 Thread James. L
> 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

Re: questions on serving big file & SQL statement parsing

2007-07-02 Thread Charlie Garrison
Good morning, On 2/7/07 at 4:27 PM -0700, James. L <[EMAIL PROTECTED]> wrote: >I am wondering how do you do it if i have to auth user >first? mod_auth_tkt Charlie -- Charlie Garrison <[EMAIL PROTECTED]> PO Box 141, Windsor, NSW 2756, Australia O< ascii ribbon campaign - stop html mai

questions on serving big file & SQL statement parsing

2007-07-02 Thread James. L
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 stat