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
