Re: [htmltmpl] speeding up an h-t website on a windoze box

[Cees H. <ce...@si...>]

Puneet Kishor wrote:
> I want to experience the dizzying effect of speed on Windoze.
> 
> Mod_perl is out because the server might be running IIS (and even if it 
> isn't, I am sure my script will have to be re-hacked).
> 
> I was hoping for IPC-SharedCache, but that doesn't seem possible on Win.
> 
> I tried CGI-Simple for some modest speed increase, but that croaked 
> because I am also using CGI-Session and I couldn't figure out how to 
> make CGI-Session work with CGI-Simple.
> 
> Other than simply increasing the hardware capability, are there any 
> insights on what I can do?
> 
> My app is a single cgi script and uses DBI, Storable, CGI, CGI-Session, 
> and, of course, H-T.

Have a look at FastCGI which should be supported in IIS.  Also checkout 
SpeedyCGI (also known as Persistent Perl), although I don't know if it 
works on Windows, as I don't use windows myself.  Those two options will 
keep the perl interpreter in memory, so that you save the startup times 
on your CGI script.  Also, if coded right, you can keep a persistent 
database connection using this as well.

If that doesn't help, then you need to profile your code to see where 
the bottlenecks are.  Chances are your database access will be the 
biggest bottleneck, but that is a generalization and depends completely 
on your code.  See Devel::DProf for info on how to profile your code.

Cheers,

Cees