run a subpage in it's own thread

[gareth7]

I am building an application where the user submits a form. The next page will make several lengthy database calls and run scripts using cfexecute.

As there can be a large amount of work for these scripts to complete, I would prefer if the user is immediately redirected to another page while these scripts process. If the user had to wait for the scripts to finish, their browser is likely to timeout or take several minutes to get the page - neither of these options is desirable.

Is there some way I can start a cold fusion page in it's own thread?

 

[webmigit]

You might consider frames or a popup window. That would seem the simplest method.

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[ecobb]

In all honesty, if you are running queries that are timing out the browser, you need to look at fixing those instead of finding a way for CF to hide it. I'm not trying to be ugly about it, but something like that should be a serious concern. That much of a constant strain on the web server and database can't be good.



Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

 

[gareth7]

Thanks for the suggestions.

I'm not quite sure how the pop-up/frames method is meant to work. Do you mean to send the form submission to a new frame/window while the original frame is redirected to a separate page? Is there some way to hide the new frame so that the user doesn't think things have stalled?

I'm afraid that the scripts are going to take a while. It isn't really the database queries that slow it down. The data from the queries is used to generate graphs and tables, these are then pasted into word docs to create a report file for the user. Due to the size of some of these reports there is only so much optimization we can do. This report process will probably be done on a separate machine if it's affecting performance

 

[webmigit]

I mean a frame scenario where the top frame just says something like "Data Generation in progress, don't close this window." and the bottom frame allows them to move around and such..

Tony

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.