Re: Wait Page

From: vMike (MichZaelY.GeZorgeY_at_noZorY.geZwaYrrenY.com)
Date: 01/27/05


Date: Thu, 27 Jan 2005 14:16:44 -0500


"PinellasBoy" <PinellasBoy@discussions.microsoft.com> wrote in message
news:2F6710E8-8B9B-42DA-9AC3-CE6D04886753@microsoft.com...
> I have an stored procedure which takes long time to execute. So I am
trying
> to execute the procedure in another thread by using the thread start
> function. After the SP starts processing I want to take the user to a
"wait"
> page and then return them after the processing is over.
>
> The wait page has http-refresh header which takes it back to the starting
> page. Once the starting page has reloaded in page_load procedure I would
> like to check whether the processing has finished and if not redirect back
to
> the wait page.
>
> Problem is I do not know how to pass data back to the application main
> thread from the secondary thread. I tried using session using
> synchlock.Session, but it errors out.
>
> I also tried to use a callback. But since the callback procedure also
> executes in a secondary thread I am getting the same error.
>
> Please help
>
Can you just stay on the page and make the wait portion visible (and the
rest not visible) while the server is processing. One way to check for
completed process is to use cache. You can put something in cache while
processing, check for it and continue the wait page if the cache item is
still present. Once the operation is completed, clear the cache can
redisplay. Don't know if this helps or not.

Mike



Relevant Pages

  • Re: "Resultcache" effect in 10.2.0.4 ??
    ... OS cache he is talking about to show it is responsible. ... the trace file should point you in the right direction as ...  a) as I said, the files are in cooked filesystems, maybe in Solaris ... execute and time the query ...
    (comp.databases.oracle.server)
  • Re: "Resultcache" effect in 10.2.0.4 ??
    ... OS cache he is talking about to show it is responsible. ... as I said, the files are in cooked filesystems, maybe in Solaris ... Run it once with a trace, log out, log ... execute and time the query ...
    (comp.databases.oracle.server)
  • Re: [BUGFIX][PATCH] DO flush icache before set_pte() on ia64.
    ... unsuccessfull attempt at montecito cache coherency. ... linux situation it can execute old cache lines straight from L2 icache. ... the code that avoids icache flushes for non-executable pages. ...
    (Linux-Kernel)
  • Re: Fw: [PATCH] ia64: race flushing icache in do_no_page path
    ... already mapped with execute and write permissions then it should be treated ... we may not even have a handle to issue the flush cache instruction on (ie. ...
    (Linux-Kernel)
  • Re: Fw: [PATCH] ia64: race flushing icache in do_no_page path
    ... already mapped with execute and write permissions then it should be treated ... we may not even have a handle to issue the flush cache instruction on (ie. ...
    (Linux-Kernel)