It turned out to be an output buffering problem. It's strange, because once I fixed the query it worked just fine.
The query doesn't happen until after I invoke the ->run() method from my CGI instance script, but the debugging output between my cgiapp object instantiation and my invokation of run() doesn't show up until after the query returns. Then I still had a long wait before the page was served up. In any case, it's working now. Thanks. -Eric. Mark Stosberg: [Saturday 15-December]: > On Fri, 14 Dec 2001, Eric Berg wrote: > > > Hanging only happens when a certain parameter set to one of 4 values. > > I would investigate more here. You might also try an interactive > debugger to see exactly where it hanging. (I like XEmacs interface to > the perl debugger). You might also check out the Devel::DProf which > can tell you exactly which subroutine call your code is spending the > most time in. > > If those tips don't solve it, try posting more detail of what you code > is doing around the "hang spot". > -mark > > > When it's set to any of the other values, it doesn't hang. This is > > all before I do anything in the code. The big query for this report > > is slow, but it's a known sql optimization problem, and besides, it > > occurs much later in the program when things really get going. > > > > here's the end of new(): > > > > $self->cgiapp_init(@args); > > > > # Call setup() method, which should be implemented in the sub-class! > > $self->setup(); > > > > return $self; > > } > > > > > > So, by my reckoning, when I leave setup, the constructor should also > > return and I should get my debug message "After new" as above. > > > > What's up here, guys? > > > > -Eric. > > > > -- > > Eric D. Berg <[EMAIL PROTECTED]> > > Web Development / Solaris-Linux / Perl / SQL > > http://nylug.org/~eberg > > Tel. 646-418-3608 > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > http://mark.stosberg.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
