I am hoping that someone could shed some light onto this little problem
that keeps creeping up once in a while. I have built a bunch of cgi pages
that do db calls via win32::odbc and spit back an html form basically.
The server is a quad processor HP LH3 with 512MB of RAM. It is running an
up to date version of w2k adv. server and has activeperl 5.6.1 installed
on it. I query a SQL 2000 db a lot for some of these pages so i thought
that could be the hang up but I ran devel::profiler and I got this from
one of my pages:
Total Elapsed Time = 0.578184 Seconds
User+System Time = 0.343184 Seconds
Exclusive Times
%Time ExclSec CumulS #Calls sec/call Csec/c Name
26.8 0.092 0.153 137 0.0007 0.0011 Win32::ODBC::DataHash
23.0 0.079 0.109 139 0.0006 0.0008 Win32::ODBC::FetchRow
13.4 0.046 0.046 1 0.0460 0.0460 CGI::_compile
13.1 0.045 0.045 139 0.0003 0.0003 Win32::ODBC::ClearError
8.74 0.030 0.030 280 0.0001 0.0001 Win32::ODBC::processError
4.66 0.016 0.061 137 0.0001 0.0004 Win32::ODBC::GetData
4.37 0.015 0.292 1 0.0150 0.2922 main::get_db_records
4.37 0.015 0.015 2 0.0075 0.0075 Win32::ODBC::ODBCConnect
0.00 0.000 0.000 545 0.0000 0.0000 Win32::ODBC::data
0.00 0.000 0.000 139 0.0000 0.0000 Win32::ODBC::ODBCCleanError
0.00 0.000 0.000 139 0.0000 0.0000 Win32::ODBC::ODBCFetch
0.00 0.000 0.000 137 0.0000 0.0000 Win32::ODBC::ODBCGetData
0.00 0.000 0.000 6 0.0000 0.0000 CGI::param
0.00 0.000 0.046 1 0.0000 0.0460 CGI::init
0.00 0.000 0.000 10 0.0000 0.0000 CGI::self_or_default
Even though the above said that the page ran in under a second, I never
got the output in my browser after waiting for 5 minutes! I took the "-w"
option away from the #!/perl at the top of the file because there were a
decent amount of stupid errors and I thought maybe that was hanging the
file. That didn't fix it either. So if the script is executing fast and
its not STDERR(i am picking at straws here) what else could be holding up
the output. I am more familiar with Perl on *nix platforms so any help
with regard to IIS or w2k might help a lot. Any help would be great! Oh
yeah, I am running the ISAPI version of Perl.
Thanks,
Justin
_______________________________________________
ActivePerl mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
