Background processing

[rickpill]

I need help in setting up a process where a determination is made that a user's Database request is too large for immediate processing and a message to the user , e.g. "Your reqest has been submitted".

If possible a later prompt to the user when it completes on the server.



Thank you,

Rick Pillay

 

[FengShui1998]

rickpill,

What is your criteria for determing a request is "too big"?

fengshui_1998

 

[rickpill]

A request that takes over 90 seconds to process.

 

[FengShui1998]

rickpill,

My question then is how do you know it will take over 90 seconds unless you process it. I'm not trying to jerk you around, but you might want to try looking into retrieving only a page full of records at a time.



fengshui_1998

 

[rickpill]

fengshui_1998,

No problem ... perhaps I better explain. Here's an example of what they might ask:

All clients who purchased over $10,000 and save all selected
rows as a campaign.

Assuming the result is 5,500 clients - what they're looking for here is not a display of clients, but saved as a file (campaign). The total number will be displayed.

How I think this should work:
. Establish a count of the number of rows
. Display counts - message "Submitted for Campaign processing"
. CREATE THE CAMPAIGN IN THE BACKGROUND.
. Message routed to user, "Campaign processing complete for ...." on completion.

Thanks,
Rick