perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Harris" <>
Subject RE: Long waits on SQL Stored Procs. Should I use chained content handlers?
Date Mon, 02 Apr 2001 23:54:12 GMT

One could handle this all in one request with an HTML layer controlled by
JavaScript that performs counting for the user. This is better that multiple
requests because you don't have to try starting processing in one HTTP
request and giving the result to another HTTP request. Run everything in one
request and life is simpler.

For an example of something I have working go to
and then search for a domain.

The box that pops up before the page has fully loaded is a layer. View the
source to see the JavaScript code controlling the layer. Replace my
machinery to perform a count in the layer with a simple animated gif if you

I don't have any public examples that show how it works when the page takes
a while to load. Those are all on the internal website.

Here is the code:

This code not supported. This is the basic idea: take it and run.

David Harris
President, DRH Internet Inc.

-----Original Message-----
From: []
Sent: Monday, April 02, 2001 10:07 AM
Subject: Long waits on SQL Stored Procs. Should I use chained content

I need to run some stored procedures that take upwards of a minute to
result sets. Ok, thats grand but I dont want the browser to sit there and

I'd like to display an animated gif. Simple. Right? I hope.

I'm looking into chained handlers in my mod_perl code, but I'm not sure if
is what I need.

0) Request page and report.
1) Push 'Waiting...' animated gif
2) Process report, Perl waits for result set
3) Perl pushes the report html to the browser as if it opened in a target =
_blank window. IE: That same window...
Stumped (or rather -> RTFMing),

Any ideas?  I cant, for the life of me, figure out how this would work with
http redirects, and thought there might be something with mod_perl that
help this.  Fork() maybe.  I'm trying a few ideas.

Thanks a bunch.  If this is slightly OT, I apologize.

Tom Sullivan,

This message was sent using Endymion MailMan.

View raw message