perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Harris" <dhar...@drh.net>
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
http://www.drh.net/site/domain/new.shtml
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
like.

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:
http://www.davideous.com/misc/Fusion-Countdown.pm

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

David Harris
President, DRH Internet Inc.
dharris@drh.net
http://www.drh.net/

-----Original Message-----
From: tls@860.org [mailto:tls@860.org]
Sent: Monday, April 02, 2001 10:07 AM
To: modperl@apache.org
Subject: Long waits on SQL Stored Procs. Should I use chained content
handlers?

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

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
this
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
would
help this.  Fork() maybe.  I'm trying a few ideas.

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

Tom Sullivan,
webmaster@860.org

---------------------------------------------
This message was sent using Endymion MailMan.
http://www.endymion.com/products/mailman/


Mime
View raw message