• Post Reply Bookmark Topic Watch Topic
  • New Topic

Suggestions on Handling Report Requests  RSS feed

 
Steve Dyke
Ranch Hand
Posts: 1783
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In several of my applications complex reports based on remote data calls and calculations(huge arrays) are generated. Some of these reports my take up to an hour to generate. Needless to say this is not acceptable to user to have to wait. I need suggestions on how that I can set up(whatever) that could monitor requests for reports and process them in the background, separtate from the clients instance of the app. Then it could notify them when the report is ready.

I had something like this in my Microsoft FoxPro Apps. One app that ran 24/7 firing on short intervals, looking at new entries in a table, and processing them.

I use Websphere(WDSC) as my IDE. Our web server runs on an AS400(iSeries) box.
 
Manish Singh
Ranch Hand
Posts: 160
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why dot you run the reports nightly and keep the values ready in the database.
 
Steve Dyke
Ranch Hand
Posts: 1783
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Manish Singh wrote:Why dot you run the reports nightly and keep the values ready in the database.


In most cases the use wants real time data.
 
David Newton
Author
Rancher
Posts: 12617
IntelliJ IDE Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Steve Dyke wrote:In most cases the use wants real time data.

Then waiting an hour won't work particularly well either.

You can always set up a task to build the report and shoot an Ajax request every minute or whatever and check for availability. Or just send it in an email.
 
Steve Dyke
Ranch Hand
Posts: 1783
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
David Newton wrote:
Steve Dyke wrote:In most cases the use wants real time data.

Then waiting an hour won't work particularly well either.

You can always set up a task to build the report and shoot an Ajax request every minute or whatever and check for availability. Or just send it in an email.


What do you mean by "set up a task"?
 
David Newton
Author
Rancher
Posts: 12617
IntelliJ IDE Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
On the server side have a task/thread/job/etc. that creates the report then either sets a flag for a request (Ajax or otherwise) to query, or just email the report.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!