Thanks for all the suggestions. Although these are all good suggestions, my
main concern was not how to get the report to work but rather a way to have the
oracle process killed if the user presses stop. Since the real issue here is
not that the report runs so long, but that the query continues to run for no
reason (since the results will never be seen).
There is no way I can generate all of the possible reports nightly, since the
user is given the ability to enter date ranges to report on.
If there is no way to catch the stop, then the only solution seems to be the
email approach. Only problem here is that if the user actually did make a
mistake (wrong date range for instance) the process generating the data would
continue to run for no purpose.
-Mike
Jeffrey Baker wrote:
> Joshua Chamas wrote:
> >
> > Mike Dameron wrote:
> > >
> > > We have several scripts using Apache::ASP and DBI, which return
> > > information from an Oracle database. The problem is that if I run a
> > > report that taken a long time (not sure how long but over 30 minutes)
> > > and the connection either times out or I hit the stop button the oracle
> > > process which gets spawned does not die. I can see in the process list
> > > that the oracle process is still tied to a httpd process and continues
> > > to eat up cpu cycles.
> > >
> >
> > Why would you run a report from a web site that would take
> > 30+ minutes to finish ? Typical web connection timeouts
> > are a few minutes or less ?
> >
> > I think the real solution is to make your reports fast enough
> > to run from a web site, like run the real report every night,
> > and cache its results in the database for later that you can get
> > them from the browser instantly.
>
> Another workable solution is to make the reports in real time, but
> deliver them by email. Use the web interface to initiate the reporting
> process and send a confirmation.
>
> Cheers,
> Jeffrey
> --
> Jeffrey W. Baker * [EMAIL PROTECTED]
> Critical Path, Inc. * we handle the world's email * www.cp.net
> 415.808.8807
--
ISIS 2000, Inc.
Your e-Partner. Not e-Vendor
e-Business, Systems Integration and Enterprise Management solutions
http://www.isis2000.com
