sorry, meant CGI. > > Switch from GCI to CGI =D > > Tony > > At 05:19 PM 10/23/02 -0400, you wrote: >>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 >> >> > > -- > even the safest course is fraught with peril
_______________________________________________ ActivePerl mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
