I think I would use a GAE task queue (it allows for longer run time and
does not take process power from actual page rendering).
The queue controller would generate the report and send a mail or change a
database value upon completion.

    from google.appengine.api import taskqueue

def action():
   …
   taskqueue.add(url=URL(f='generate_report'),
                            params={'userid': row.id})

def generate_report():
   userid = request.vars.userid
   …

​

On Sat, Jun 10, 2017 at 10:54 AM Karoly Kantor <kar...@kantor.hu> wrote:

> I have a rather complex data base structure on which I need to enable
> users to define various reports and run them in the background. (As the
> generation time might exceed what is acceptable real-time.) I want to
> enable users to launch the generation of these reports and then get a
> notification when the report is done and ready for download. I am on Google
> App Engine / Cloud SQL.
>
> 1. What are my architectural options to achieve this? What is the
> recommended setup?
> 2. How can I ensure that background report generation is done with lower
> priority than real time page requests, to make sure that background report
> generation jobs will not degrade primary user experience?
>
> Thank you.
>
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to